| From: | "Simon Stiefel" <pgsqlml(at)nuclear-network(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Question on database structure |
| Date: | 2003-11-06 18:29:08 |
| Message-ID: | 064c01c3a493$df110c10$1401a8c0@panic |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2003-11-06 18:32:18 | Re: tsearch2 and gist index bloat |
| Previous Message | Eliu Montoya | 2003-11-06 18:26:48 | Insert and obtain the pk |