From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
---|---|
To: | shridhar_daithankar(at)persistent(dot)co(dot)in |
Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Large databases, performance |
Date: | 2002-10-07 15:22:41 |
Message-ID: | cl83quoi1kt2ebcsbajm18iekkporrj9f5@4ax.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-performance pgsql-sql |
On Mon, 07 Oct 2002 19:48:31 +0530, "Shridhar Daithankar"
<shridhar_daithankar(at)persistent(dot)co(dot)in> wrote:
>I say if it's a char field, there should be no indicator of length as it's not
>required. Just store those many characters straight ahead..
This is out of reach for a quick hack ...
>Sure. But the server machine is not available this week. Some other project is
>using it. So the results won't be out unless at least a week from now.
:-)
>This time results are correct. Postgresql loads data faster, indexes it faster
>and queries in almost same time.. Way to go..
Great! And now let's work on making selects faster, too.
Servus
Manfred
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2002-10-07 15:31:51 | Re: why isn't index used? |
Previous Message | Tom Lane | 2002-10-07 15:21:57 | Re: [pgsql-performance] Large databases, performance |
From | Date | Subject | |
---|---|---|---|
Next Message | Hans-Jürgen Schönig | 2002-10-07 15:23:03 | Re: Table spaces again [was Re: Threaded Sorting] |
Previous Message | Tom Lane | 2002-10-07 15:21:57 | Re: [pgsql-performance] Large databases, performance |
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB SD | 2002-10-07 15:42:12 | Re: [HACKERS] Large databases, performance |
Previous Message | Tom Lane | 2002-10-07 15:21:57 | Re: [pgsql-performance] Large databases, performance |
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Luc Lachance | 2002-10-07 15:55:10 | Re: enforcing with unique indexes.. |
Previous Message | Tom Lane | 2002-10-07 15:21:57 | Re: [pgsql-performance] Large databases, performance |