Hi all,
First of all, please pardon if the question is dumb! Is it even feasible or
normal to do such a thing ! This query is needed by a webpage so needs to be
lightning fast. Anything beyond 2-3 seconds is unacceptable performance.
I have two tables
CREATE TABLE runresult
(
id_runresult
like that is even advisable at
all ...
Thanks,
Amit
-Original Message-
From: Dmitri Bichko [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 08, 2005 1:47 PM
To: Amit V Shah; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Joining 2 tables with 300 million rows
What's
Hi all,
I have like a repository table with is very very huge with atleast a few
hundreds of millions, may be over that. The information is stored in form of
rows in these tables. I need to make that information wide based on some
grouping and display them as columns on the screen.
I am thinking
if someone can comment on that)
So that is my situation.
Again, thanks everyone for helping
Amit
-Original Message-
From: John A Meinel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 21, 2005 11:01 AM
To: Amit V Shah
Cc: '[EMAIL PROTECTED]'; pgsql-performance@postgresql.org
Subject: Re: [PERFORM
Hi all,
Thanks for your replies.
I ran a very prelimnary test, and found following results. I feel they are
wierd and I dont know what I am doing wrong !!!
I made a schema with 5 tables. I have a master data table with foreign keys
pointing to other 4 tables. Master data table has around 4
I am all for postgres at this point, however just want to know why I am
getting opposite results !!! Both DBs are on the same machine
Why do you say opposite results ?
Please pardon my ignorance, but from whatever I had heard, mysql was
supposedly always faster than postgres Thats
Hi all,
From whatever reading and surfing I have done, I have found that postgres is
good. Actually I myself am a fan of postgres as compared to mysql. However I
want to have some frank opinions before I decide something. Following are
some of the aspects of my schema, and our concerns --
- We
with postgres or
mysql.
Thanks,
Amit
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 24, 2005 1:15 PM
To: Amit V Shah
Cc: 'pgsql-performance@postgresql.org'
Subject: Re: [PERFORM] Need help to decide Mysql vs Postgres
I am not trying to start a mysql vs
- Most of the DB usage is Selects. We would have some inserts but that
would be like a nightly or a monthly process
So transaction integrity is not a real concern? This sounds like a data
warehouse; wanna try Bizgres? (www.bizgres.org)
I took a look at this. I have a few concerns with