Re: [ADMIN] Help request: how to tune performance?

2008-09-18 Thread Mauri Sahlberg
Hi, Thanks for the reply and advice. Scott Marlowe kirjoitti: Version : 8.1.11Vendor: CentOS So, you built it its own machine, but you didn't upgrade to at least 8.2? Now it is: 8.4devel_15092008 The machine was installed by the production team from

[ADMIN] Help request: how to tune performance?

2008-09-16 Thread Mauri Sahlberg
Hi, We just upgraded Best Practical's RT from 3.6 to 3.81 and gave the database completely own machine. And the users still complain that it is dog slow. :-( I installed pg_top and it seems that at the beginning of the ticket display RT-issues a query that eats everything the database has. Query i

Re: [ADMIN] Stupid question about triggers

2005-09-11 Thread Mauri Sahlberg
Robert Treat wrote: >On Friday 09 September 2005 09:20, Mauri Sahlberg wrote: > > >>Hi, >> >>I have found myself in a situation where I need to quickly delete rows >>from a production database. Unfortunately table for the rows to be >>deleted have trigger

[ADMIN] Stupid question about triggers

2005-09-09 Thread Mauri Sahlberg
Hi, I have found myself in a situation where I need to quickly delete rows from a production database. Unfortunately table for the rows to be deleted have triggers which results massive chain of update operations on other tables. I do not wish those to happen as I'm about to delete concerned rows

Re: [ADMIN] A nightmare

2005-05-04 Thread Mauri Sahlberg
ma, 2005-05-02 kello 10:52 -0400, Tom Lane kirjoitti: > Mauri Sahlberg <[EMAIL PROTECTED]> writes: > > I'm starting to become desperate. On saturday I dumped all databases, > > wiped whole postgresql installation. Installed newest rpms for Fedora 1, > > resto

[ADMIN] A nightmare

2005-05-01 Thread Mauri Sahlberg
Hi, I'm starting to become desperate. On saturday I dumped all databases, wiped whole postgresql installation. Installed newest rpms for Fedora 1, restored databases. Recompiled client libraries and binaries. Restarted and after five hours of operation: May 1 21:34:19 claymountain postgres[6337]:

[ADMIN] Backing up users?

2005-04-30 Thread Mauri Sahlberg
hadow and pg_group that are related to the database in question and insert them in the new environment? (The rows to use could probably be deducted from other catalog tables and views by queries...) Regards, Mauri Sahlberg ---(end of broadcast)---

Re: [ADMIN] Help desperately needed: reoccurring invalid page

2005-04-28 Thread Mauri Sahlberg
Hi, Ian Westmacott wrote: >Mauri, I'm no expert but I can tell you what I know. We >have experienced this same problem, and I asked a >similar question not too long ago. > >- This is probably due to some sort of I/O problem. In > our case, it occurs very frequently on reboots, and > it app

[ADMIN] Help desperately needed: reoccurring invalid page header

2005-04-27 Thread Mauri Sahlberg
of the four serendipity databases we have, I do not yet know which one Apr 28 08:46:45 claymountain postgres[14998]: [3-2] DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/": No such file or directory Regards, Mauri Sahlberg ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[Fwd: Re: [ADMIN] RHDB just sits and does nothing?]

2004-06-09 Thread Mauri Sahlberg
Hi, What an earth I am doing wrong? I am trying to delete about 6500 rows and I am the only user connected to the database and it just sits there and does nothing? Jun 9 10:02:44 pihsi postgres[31547]: [25] LOG: query: begin; Jun 9 10:02:44 pihsi postgres[31547]: [26] LOG: duration: 0.000181

[ADMIN] RHDB just sits and does nothing?

2004-06-09 Thread Mauri Sahlberg
Hi, What an earth I am doing wrong? I am trying to delete about 6500 rows and I am the only user connected to the database and it just sits there and does nothing? rahaks=# select count(*) from tilikartta where yritys=18231413; count --- 6347 (1 row) rahaks=# explain delete from tilikartt

Re: [ADMIN] Procedures, triggers and transactions...

2004-01-26 Thread Mauri Sahlberg
su, 2004-01-25 kello 23:08, Tom Lane kirjoitti: > Mauri Sahlberg <[EMAIL PROTECTED]> writes: > > The framework is that a c++ application transforms xml-input data to > > sql-procedure calls with appropriate parameters who in turn call another > > procedures who in t

[ADMIN] Procedures, triggers and transactions...

2004-01-25 Thread Mauri Sahlberg
uggestions? Regards, -- Mauri Sahlberg <[EMAIL PROTECTED]> Claymountain Solutions Oy ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] ER diagram tool for PostgresSQL7.3

2003-11-11 Thread Mauri Sahlberg
purpose. My solution is to keep the diagrams updated so that I don't need reverse engineering. ;) Regards, -- Mauri Sahlberg <[EMAIL PROTECTED]> Claymountain Solutions Oy ---(end of broadcast)--- TIP 3: if posting/reading through Usene

Re: [ADMIN] plpgsql: Bush becomes a null,

2003-08-28 Thread Mauri Sahlberg
both of my questions have been kind of RTFM questions, had I just thought them out! The only two places I've got answers so fast have been Datavision and Inetd-software. > Mauri Sahlberg <[EMAIL PROTECTED]> writes: >> If the following is executed in context, where the dynamic qu

[ADMIN] plpgsql: Bush becomes a null, can not execute null query

2003-08-28 Thread Mauri Sahlberg
Hi, This time I think this is a bug, but where? In my code or in plpgsql? Or in my understanding of dynamic queries? If the following is executed in context, where the dynamic query returns data with every iteration everythin goes fine. If the the dynamic query returns nothing - bush becomes null

Re: [ADMIN] Parallel transactions failing oddly

2003-08-01 Thread Mauri Sahlberg
On pe, 2003-08-01 at 03:12, Stephan Szabo wrote: > > interface. If we run them one by one everything goes fine. But if I > > run them in parallel - in separate processes - all but the first one > > claiming the lock for "ryhmalaiset"-table will fail. And they will > > fail as soon as the first one

Re: [ADMIN] Parallel transactions failing oddly

2003-07-31 Thread Mauri Sahlberg
On pe, 2003-08-01 at 09:21, Stephan Szabo wrote: > On 1 Aug 2003, Mauri Sahlberg wrote: > > > On pe, 2003-08-01 at 08:51, Stephan Szabo wrote: > > > On 1 Aug 2003, Mauri Sahlberg wrote: > > > > > > > On pe, 2003-08-01 at 03:12, Stephan Szabo wrote: > &

Re: [ADMIN] Parallel transactions failing oddly

2003-07-31 Thread Mauri Sahlberg
On pe, 2003-08-01 at 08:51, Stephan Szabo wrote: > On 1 Aug 2003, Mauri Sahlberg wrote: > > > On pe, 2003-08-01 at 03:12, Stephan Szabo wrote: > > > > interface. If we run them one by one everything goes fine. But if I > > > > run them in parallel - in separa

Re: [ADMIN] Parallel transactions failing oddly

2003-07-31 Thread Mauri Sahlberg
On pe, 2003-08-01 at 03:12, Stephan Szabo wrote: > > interface. If we run them one by one everything goes fine. But if I > > run them in parallel - in separate processes - all but the first one > > claiming the lock for "ryhmalaiset"-table will fail. And they will > > fail as soon as the first one

[ADMIN] Parallel transactions failing oddly

2003-07-31 Thread Mauri Sahlberg
Hi, Either we have found a bug in Postgres (which I seriously doubt) or we are being stupid clever enough way to not notice it. We have five complex "transactions" that are executed thru pq++/c++ interface. If we run them one by one everything goes fine. But if I run them in parallel - in separat

Re: [ADMIN] Registering all User Operations

2003-01-25 Thread Mauri Sahlberg
On su, 2003-01-26 at 03:03, Bruce Momjian wrote: > Uh, you can turn on log_statements in postgresql.conf and they will > appear in the server logs. > > --- > Logging options are explained in the Administrator's manual at cha