Re: [SQL] slowing down too fast - why ?

2002-08-11 Thread Marc Spitzer
On Sun, Aug 11, 2002 at 02:10:34PM -0400, [EMAIL PROTECTED] wrote: > > I've even launched the backend with "-F" and removed BEGIN/COMMIT and > LOCK TABLE and FOR UPDATE, but I still get slow response. > > only when count(*) from file is 16000, I get about 2-3 rows / second on > average. When

Re: [SQL] 1 milion data insertion

2002-07-26 Thread Marc Spitzer
On Fri, Jul 26, 2002 at 03:34:12PM -0300, Elielson Fontanezi wrote: > Hi fellows! > > I have tried to insert 1.000.000 of record to the following table; > > -- > zakal=# \d teste; > codigo | bigint | not null > nome | char

Re: [SQL] Editor for pgsql

2002-07-22 Thread Marc Spitzer
On Mon, Jul 22, 2002 at 04:09:21PM -0400, James Orr wrote: > On Monday 22 July 2002 12:27 pm, Josh Berkus wrote: > > > Me, I use Kate, an MDI text editor from the KDE crew, and CVS for > > version control. Thanks, KDE guys!But, after 3 years of Postgres, > > I'm pretty fluent in PL/pgSQL.

Re: [SQL] XML to Postgres conversion

2002-07-12 Thread Marc Spitzer
On Thu, Jul 11, 2002 at 09:23:39AM -0500, [EMAIL PROTECTED] wrote: > Look at contrib/xml at > http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/xml/. I never > used this, but it might be useful. > > George Essig > > > Hello. > > > > I am trying to figure out how to import xml documents i

Re: [SQL] Slow SELECT -> Growing Database

2002-06-27 Thread Marc Spitzer
On Thu, Jun 27, 2002 at 04:24:04PM +0100, Marcos Garcia wrote: > On Mon, 2002-06-24 at 22:43, Stephan Szabo wrote: > > On 24 Jun 2002, Marcos Garcia wrote: > > > > Hmm, that should only happen if you're doing alot of updates or deletes > > I would guess (updates would cause it to slow down as wel

Re: [SQL] Index of a table is not used (in any case)

2001-10-23 Thread Marc Spitzer
In article <[EMAIL PROTECTED]>, Josh Berkus wrote: > Reinier, > > For future notice, [SQL] is the correct list for this kind of inquiry. > Please do not post it to [HACKERS]. And please don't cross-post ... it > results in a lot of needless duplication of effort. > >> I have defined a table and