Re: Question on database structure - Mailing list pgsql-general

From Simon Stiefel
Subject Re: Question on database structure
Date
Msg-id 064c01c3a493$df110c10$1401a8c0@panic
Whole thread Raw
In response to Re: Question on database structure  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> Gaetano Mendola wrote:
>
> You are going to have nightmares for your queries then.

Well, it's ok. As far as I know the zip code I can modify my query.
But it would be better, if I don't have to think about that modification.

> How much rows you will have in these two tables ?

There would be about 1,2 million rows altogether.

> With postgres Tables of milions rows with the right index are
> queried in few millisecond.

Ah, thats good to hear.
So I'm going to throw them together. :)

Thanks for your help!

Greetings,
    Simon
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)

iD8DBQE/qpLytbkSnV7uFrYRAqH/AJwJqWbqdcPFBV5ZPUmZBVCMgf0ANwCfYiAZ
5JVnrHBFDnN97lXxCooc008=
=5V/E
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From: "Carlos Oliva"
Date:
Subject: Re: Install files for version 7.4
Next
From: "Eliu Montoya"
Date:
Subject: Insert and obtain the pk