This might not be 100% performance compilant but i guess its better than
-hackers since
these day's there seem to be some big consern :)
So feel free to comment
[Abstract: Underlyin plpgsql should remove all public user ACL's from
Function,Table Sequence,View ... ]
-elz
--
On 6/20/06, Merkel Marcel (CR/AEM4) <[EMAIL PROTECTED]> wrote:
I use libpqxx to access the database. This might be another bottleneck, but
I assume my query and table setup is the bigger bottleneck. Would it make
sense to fetch the whole array ? (Select map from table where … and parse
the arra
Hi all,I just saw another email on the mailing list to this effect as well. We recently updated the kernel versions on our machines to the latest stable versions (which contained both HyperThreading and IO bug fixes) and we updated Postgres to version
8.0.8. We thought we were in the clear when
Hi, Chris,
Chris Mair wrote:
> Now I was wondering whether one could have a
> SELECT pg_setpriority(10);
> executed automatically each time a certain user
> connects (not necessarily using psql)?
>
> Any ideas if and how this might be possible?
When using Java, most Datasource implementations
[EMAIL PROTECTED] writes:
> [slow:]
> OPEN cursor1 FOR SELECT * FROM alias WHERE mask>=alias_out
> ORDER BY mask;
> [fast:]
> OPEN cursor1 FOR SELECT * FROM alias WHERE mask>=alias_out
> ORDER BY mask LIMIT 100;
The difference is that in the first case the planner has to assume you
Hi
I have following table:
CREATE TABLE alias (
alias_id BIGSERIAL PRIMARY KEY,
mask VARCHAR(20) NOT NULL DEFAULT '',
);
with index:
CREATE INDEX alias_mask_ind ON alias(mask);
and this table has about 1 million rows.
In DB procedure I execute:
Title: Big array speed issues
Hi,
I have some speed issues with a big array in a table. I hope you can help me to tune my query.
My table looks like this:
Id | timestamp | map
Primary key | timestamp | array of real [34][28]
With an index on timestamp
My query
