| 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: | Whole Thread | Raw Message | 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 |