star-schema?
Joanne
-Original Message-
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Tuesday, November 10, 2015 11:16 AM
To: Jim Nasby
Cc: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Slow response if pulling through pgadmin
I would also like t
(through an odbc connector) it
takes 3 minutes for the data to come back.
-Original Message-
From: Jim Nasby [mailto:jim.na...@bluetreble.com]
Sent: Tuesday, November 10, 2015 11:08 AM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Slow response if pulling thr
I would also like to add that I am very suspicious of a table with 80 columns.
Offhand, it sounds like poor database design where someone was trying
to put all the eggs in one basket (figuratively).
Further, what was the exact query?
Queries of the form SELECT * will always be inherently slow with
m Nasby
Cc: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Slow response if pulling through pgadmin
I would also like to add that I am very suspicious of a table with 80 columns.
Offhand, it sounds like poor database design where someone was trying to put
all the eggs in
connector) it
takes 3 minutes for the data to come back.
-Original Message-
From: Jim Nasby [mailto:jim.na...@bluetreble.com]
Sent: Tuesday, November 10, 2015 11:08 AM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Slow response if pulling through pgadmin
O
On 11/10/15 9:39 AM, Mammarelli, Joanne T wrote:
Hi – same rookie user as before.
We have one table
100,000 rows
80 columns
When we try to retrieve the data (select * from table) using pgadmin, we
get a 193456 ms retrieve time.
When I ran a query analyze in the command prompt, we get a 316ms
On 11/10/2015 07:39 AM, Mammarelli, Joanne T wrote:
Hi – same rookie user as before.
We have one table
100,000 rows
80 columns
When we try to retrieve the data (select * from table) using pgadmin, we
get a 193456 ms retrieve time.
Where is the client(pgAdmin) relative to the server?
Where
Hi - same rookie user as before.
We have one table
100,000 rows
80 columns
When we try to retrieve the data (select * from table) using pgadmin, we get a
193456 ms retrieve time.
When I ran a query analyze in the command prompt, we get a 316ms retrieve time.
.. and finally. When we retrieve
