Hi
sorry for my english
My serwer is:
p4 2.4 Ghz, 1 GB RAM, data from postgres on RAID 0 SCSI
(hardware scsi)
some tables (about 15) have 50.000 position, and all data (pgdumpall) are
about 600 MB
I have apache 1.3.29 - and he use the database for generate pages.
So my problem is performance thi
On Tue, Mar 11, 2003 at 15:42:41 +0700,
Ruslan A Dautkhanov <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> Just a little simple example:
>
> isbs=# \d radauth
>Table "public.radauth"
> Column |Type | Modifiers
> --+
Hello all,
Just a little simple example:
isbs=# \d radauth
Table "public.radauth"
Column |Type | Modifiers
--+-+---
dttm | timestamp(0) with time zone |
user
We are currently trying to use PostgreSQL in a high throuput OLTP style
application.
Without trying to give you all the details of what we are doing(There is
quite a bit) I just want to explain the problem and in general what we are
doing. I am sure this will be something you have come accrross b
Reinhard Max <[EMAIL PROTECTED]> writes:
> It has a unique index on id, non-unique indexes on all othe columns,
> and contains approx. 35 rows.
Do you actually *need* an index on every single column? How many of
those columns are you actually going to use for searches on a frequent
basis?
C
Hi,
I am not sure whether the behaviour described below is to be expected
or to be considered as a bug, but I bet you can tell me ;)
I have a table defined as follows:
CREATE TABLE "foo" (
"id" int NOT NULL,
"name" character varying(256) NOT NULL,
"street" character vary
On Wed, 19 Sep 2001, Tom Lane wrote:
> John Summerfield <[EMAIL PROTECTED]> writes:
> > Or if it is reusing them, it's renaming them too.
>
> That is what the "recycling..." message is all about...
>
1) Why rename them?
2) Does anyone have a better idea how it floods my cache?
I'll try again w
John Summerfield <[EMAIL PROTECTED]> writes:
> Or if it is reusing them, it's renaming them too.
That is what the "recycling..." message is all about...
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' the
On Mon, 17 Sep 2001, Thomas Lockhart wrote:
> ...
> > I think that if it actually reused them instead of deleting old files...
>
> That is in fact what it does for at least the upcoming 7.2 release.
>
>
It's not what I see now in 7.2devel. Unless the changes are uncommitted (or commited
in the
...
> I think that if it actually reused them instead of deleting old files...
That is in fact what it does for at least the upcoming 7.2 release.
- Thomas
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
htt
I checked out the latest updates about 14 hours ago.
I've also put together a new box, featuring an Athlon running at 1.3 Mhz. I cloned the
OS (Red Hat Linux 7.1) - I'd copied it from one disk to another fairly recently, and
so the software setup is pretty well precisely what I've been using al
11 matches
Mail list logo
