On Sunday 27 January 2002 20:31, Sean Chittenden wrote:
> > > We have a fresh database and have begun to observe performance
> > > degradation for INSERTs as a table went from empty to 100,000-ish
> > > rows. Initial INSERTs were sub second while after 30k rows, they
> > > were 1-3 seconds.
> >
>
You could set the authentification
method to "trust" for the host the script is being run from, so you
won't get a password prompt at all (see the pg_hba.conf file).
- Original Message -
From:
Lau NH
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Tuesday, January 29,
Hi,
I am running a query on postgres 7.1.3 at Red Hat 7.2 (2 CPUs, 1.5G RAM, 2
drive disk array).
select count(*) from contact a, contact_discard b where a.contacthandle <>
b.contacthandle;
Table contact has over 9 million rows, contact_diacard has around 259,000
rows, both tables define contac
Anna,
I'm not sure that this query is doing what you think it's doing.
Since your tables aren't linked you'll end up with count(contact) *
count(contact_discard) rows to evaluate, or
9,000,000*259,00=2,331,000,000,000 (2.3 trillion) rows.
Assuming that you want to find the
On Tue, Jan 29, 2002 at 10:57:01AM -0500, Zhang, Anna wrote:
> Hi,
> I am running a query on postgres 7.1.3 at Red Hat 7.2 (2 CPUs, 1.5G RAM, 2
> drive disk array).
> select count(*) from contact a, contact_discard b where a.contacthandle <>
> b.contacthandle;
What are you trying to do with th
"Zhang, Anna" <[EMAIL PROTECTED]> writes:
> select count(*) from contact a, contact_discard b where a.contacthandle <>
> b.contacthandle;
Did you really mean "<>" here? If so, the plan you showed us is not for
this query. The above query is going to take approximately forever to
execute :-(
I
Thanks Peter Darley, Ross J. Reedstrom and Tom lane!!
How silly am I! Your messages reminds me. Actually I want to insert rows of
contact_discard table which are not exists in contact table to contact table
(some duplicates in two tables), first I run
insert into contact
select * from contact_dis
On Tue, Jan 29, 2002 at 12:23:17PM -0500, Zhang, Anna wrote:
> Thanks Peter Darley, Ross J. Reedstrom and Tom lane!!
> How silly am I! Your messages reminds me. Actually I want to insert rows of
> contact_discard table which are not exists in contact table to contact table
> (some duplicates in tw
Just to complete the thread.
Ross
- Forwarded message from "Zhang, Anna" <[EMAIL PROTECTED]> -
From: "Zhang, Anna" <[EMAIL PROTECTED]>
To: "'Ross J. Reedstrom'" <[EMAIL PROTECTED]>
Subject: RE: [ADMIN] tuning SQL
Date: Tue, 29 Jan 2002 14:08:53 -0500
Return-Receipt-To: "Zhang, Anna" <[E
Hi,
I have a problem with pg_restore. I have a database, named DEPG. I
have taken backup with pg_dump and -Ft options. I created another
database, named test. After this , I used the pg_restore command to
restore the DEPG backup into test database. Then it is restoring upto
some point and faili
[EMAIL PROTECTED] (Srinivasa Rao Chava) writes:
> I have a problem with pg_restore. I have a database, named DEPG. I
> have taken backup with pg_dump and -Ft options. I created another
> database, named test. After this , I used the pg_restore command to
> restore the DEPG backup into test data
hi all,
i am very new to this list. i have looked in the docs and have tried to
search the archives and i can not find reference to this:
how do i get psql to give me statistics about how long it took to perform
a query?
for instance, if i do:
select count(table_id) from table;
i want psql to
Hi all,
I have one table containing data
as "source.txt" attached file. I want to create a script to clean the data
and get the result as "result.txt" attached file. inbtime and inbtime1 is datetime data
type.
Anyone has an idea?
Any help will be
appreciated.
thanks in a
On Mon, 28 Jan 2002 19:40:02 + (UTC)
Andy Ruhl <[EMAIL PROTECTED]> wrote:
> On Mon, 28 Jan 2002, Steve Boyle (Roselink) wrote:
>
> > I think that there is a database created as part of the regression tests
> > that you can probably use (src/test/regress).
>
> And since you referenced src, i
On Wed, 30 Jan 2002, lonh SENG wrote:
> Hi all,
>
> I have one table containing data as "source.txt" attached file. I
> want to create a script to clean the data and get the result as
> "result.txt" attached file.
> inbtime and inbtime1 is datetime data type.
> Anyone has an idea?
>
Thank all of you very much. It works now.
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "lonh SENG" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 30, 2002 9:14 AM
Subject: Re: [ADMIN] SQL Script
>
> On Wed, 30 Jan 2002, lonh SENG wrote:
>
>
On Tue, 29 Jan 2002, GB Clark wrote:
> > And since you referenced src, it must be within the source tree? I don't
> > have the source tree but I'll grab it. The ports tree in FreeBSD is just
> > so convenient... No source trees to maintain...
>
> If your building from ports then look in the work
> > > > We have a fresh database and have begun to observe performance
> > > > degradation for INSERTs as a table went from empty to
> > > > 100,000-ish rows. Initial INSERTs were sub second while after
> > > > 30k rows, they were 1-3 seconds.
> > >
> > > we just hit this problem when moving old
Hi, All!
Is there (in psql) any way to output link and formating tags in \H
output mode?
When I did
select ''||id||'' from ...
I got < and > in place of < and >
Mark
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unre
19 matches
Mail list logo
