Re: [PERFORM] Joining 2 tables with 300 million rows

joining 2 tables 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

[PERFORM] Joining 2 tables with 300 million rows

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 int8

Re: [PERFORM] Do Views execute underlying query everytime ??

each screen. (Would be nice 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]'; pgsq

Re: [PERFORM] Do Views execute underlying query everytime ??

that can work, but the thing is I want to get manual intervention out, and besides, my work flow is very complex so this might not be an option for me :-( Thanks, Amit -Original Message- From: Matthew Nuzum [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 10:45 AM To: Amit V Shah Cc

[PERFORM] Do Views execute underlying query everytime ??

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

Re: [PERFORM] Need help to decide Mysql vs Postgres

> 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 Th

Re: [PERFORM] Need help to decide Mysql vs Postgres

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 mill

Re: [PERFORM] Need help to decide Mysql vs Postgres

> - 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 biz

Re: [PERFORM] Need help to decide Mysql vs Postgres

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

[PERFORM] Need help to decide Mysql vs Postgres

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