pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
select * from a 3M-row table very slow
3+ messages / 3 participants
[nested] [flat]

* select * from a 3M-row table very slow
@ 2007-07-02 14:23  Jessica Richard <rjessil@yahoo.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Jessica Richard @ 2007-07-02 14:23 UTC (permalink / raw)
  To: pgsql-admin

Is there anything that can make this faster? Is there any memory config (postgres and OS) that can be tuned? it came back very quick under Informix.
Thanks.

  
---------------------------------
Looking for earth-friendly autos? 
 Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.  

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: select * from a 3M-row table very slow
@ 2007-07-02 14:31  Daniel Alvão Carvalho Júnior <danieljunior@linuxmail.org>
  0 siblings, 0 replies; 3+ messages in thread

From: Daniel Alvão Carvalho Júnior @ 2007-07-02 14:31 UTC (permalink / raw)
  To: pgsql-admin

Hi !
Tell us your hardware and software configurations.
[]s


> ----- Original Message -----
> From: "Jessica Richard" <rjessil@yahoo.com>
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] select * from a 3M-row table very slow
> Date: Mon, 2 Jul 2007 07:23:29 -0700 (PDT)
> 
> 
> Is there anything that can make this faster? Is there any memory 
> config (postgres and OS) that can be tuned? it came back very quick 
> under Informix.
> Thanks.
> 
> 
> ---------------------------------
> Looking for earth-friendly autos?
>   Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.

>


=


-- 
Powered by Outblaze



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: select * from a 3M-row table very slow
@ 2007-07-02 16:04  André José Guergolet <AGuergolet@compugraf.com.br>
  0 siblings, 0 replies; 3+ messages in thread

From: André José Guergolet @ 2007-07-02 16:04 UTC (permalink / raw)
  To: Daniel Alvão Carvalho Júnior <danieljunior@linuxmail.org>; pgsql-admin

Please, send your query, table definition and indexes and the execution plan.

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Daniel Alvão Carvalho Júnior
Sent: segunda-feira, 2 de julho de 2007 11:31
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] select * from a 3M-row table very slow

Hi !
Tell us your hardware and software configurations.
[]s


> ----- Original Message -----
> From: "Jessica Richard" <rjessil@yahoo.com>
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] select * from a 3M-row table very slow
> Date: Mon, 2 Jul 2007 07:23:29 -0700 (PDT)
> 
> 
> Is there anything that can make this faster? Is there any memory 
> config (postgres and OS) that can be tuned? it came back very quick 
> under Informix.
> Thanks.
> 
> 
> ---------------------------------
> Looking for earth-friendly autos?
>   Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.

>


=


--
Powered by Outblaze

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-07-02 16:04 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-02 14:23 select * from a 3M-row table very slow Jessica Richard <rjessil@yahoo.com>
2007-07-02 14:31 Re: select * from a 3M-row table very slow Daniel Alvão Carvalho Júnior <danieljunior@linuxmail.org>
2007-07-02 16:04 Re: select * from a 3M-row table very slow André José Guergolet <AGuergolet@compugraf.com.br>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox