[GENERAL] failed sanity check, table answers was not found

2001-04-17 Thread Marek Pętlicki
but I am affraid that the dumps are corrupt. regards -- Marek Pętlicki <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] updates way slower than selects?

2001-04-13 Thread Marek Pętlicki
operation (a few inserts/deletes on a single transaction) takes 20% of the previous time which is much more satisfactory to me (and my employers ;-) Any further ideas will be more than appreciated, for the sake of my future attempts. thanks and best regards. -- Marek Pętlicki <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] updates way slower than selects?

2001-04-08 Thread Marek Pętlicki
On Saturday, April, 2001-04-07 at 23:04:23, Doug McNaught wrote: > Marek Pętlicki <[EMAIL PROTECTED]> writes: > > > Hi! > > > > I've got a question: has anybody noticed in your production > > tables, that updates on existing rows take longe

[GENERAL] updates way slower than selects?

2001-04-07 Thread Marek Pętlicki
lication as well as for the users). But I think that triggers are not the problem here, because the same ones are used for 'insert' and for 'update'. regards and best wishes -- Marek Pętlicki [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] PostGreSql 7.1

2001-03-30 Thread Marek Pętlicki
On Friday, March, 2001-03-30 at 13:13:56, Jack wrote: > Hi, All > > Where can I get a PostGreSQL 7.1 lattest beta version with RPM installation? maybe ftp://ftp.postgresql.org/pub/dev/test-rpms/ I don't know, I've never tried them (using RH I prefer own compilation).

Re: [GENERAL] how to load a sql-file????

2001-03-29 Thread Marek Pętlicki
On Wednesday, March, 2001-03-28 at 16:55:55, will trillich wrote: > On Thu, Mar 29, 2001 at 12:17:31AM +0200, Marek Pętlicki wrote: > > On Tuesday, March, 2001-03-27 at 21:42:39, markus jais wrote: > > > > > > in MySQL I can type something like in Bash on my linux b

Re: [GENERAL] Vacuum VS Vacuum Analyze

2001-03-25 Thread Marek Pętlicki
notice ;-) (it takes approx. 5 minutes) The other solution would be not to drop the unique indices (but I don't know the speed penalty in this case). Question is: have I misspotted something? Is this routine of any danger that I fail to notice? regards -- Marek Pętlicki <[EMAIL

[GENERAL] Re: [ADMIN] New PostgreSQL session monitor

2001-03-17 Thread Marek Pętlicki
compile PostgreSQL. The > later method is recommended. will the patch be included in the final 7.1 release? regards -- Marek Pętlicki <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] Re: pgsql for Python

2001-03-05 Thread Marek Pętlicki
On Friday, March, 2001-03-02 at 14:16:02, Joel Burton wrote: > On Wed, 28 Feb 2001, [iso-8859-2] Marek Pętlicki wrote: > > > Has anybody used http://sourceforge.net/projects/pgsql ? > > I maintain production system based on Python and PostgreSQL. > > > > I cur