Hi Josh,
Thanks. I've adjusted my effective_cache_size to 5 GB, so we'll see
how that goes.
I'm also doing some query and de-normalization optimizations so we'll
see how those go too.
Brendan Duddridge | CTO | 403-277-55
Brendan,
> But just as a follow up question to your #1 suggestion, I have 8 GB
> of ram in my production server. You're saying to set the
> effective_cache_size then to 5 GB roughly? Somewhere around 655360?
> Currently it is set to 65535. Is that something that's OS dependent?
> I'm not sure how
On 2 apr 2006, at 10.31, Ключников А.С. wrote:
What is faster?
One trigger with 1000 ELSE IF
Or 1000 rules
Faster to write and easier to maintain would be to write a trigger
function in pl/pgsql which executes the right function dynamically:
CREATE OR REPLACE FUNCTION exec_device_type() RE
On Sun, 2 Apr 2006, Jan Kesten wrote:
> Stephan Szabo schrieb:
>
> > Did you reset the table contents between these two (remember that
> > explain analyze actually runs the query)? The second appears to be
> > changing no rows from the output.
>
> I for myself did not, but as there are runnig aut
Stephan Szabo schrieb:
> Did you reset the table contents between these two (remember that
> explain analyze actually runs the query)? The second appears to be
> changing no rows from the output.
I for myself did not, but as there are runnig automatic jobs
periodically I can't tell, if one ran i
"Bruno Baguette" <[EMAIL PROTECTED]> wrote
>
>
> Is there a way to log all SQL queries, with the date/time when they were
> launched, and the cost of that query (if this is possible) in order to see
> which queries need to be optimized ?
>
See if log_statement, log_statement_stats parameters ca
""Rodrigo Madera"" <[EMAIL PROTECTED]> wrote
>
> The database is holding large ammounts of digital video, and I am
> wanting to put these directly into the database. What performance
> guidelines would you all give seeing my position today?
>
IMHO, if you don't need transaction semantics, don't p
""Gábriel Ákos"" <[EMAIL PROTECTED]> wrote
>
> I've got this message while heavily inserting into a database. What should
> I tune and how? It is postgresql 8.1.3.
>
> 2006-03-29 14:16:57.513 CEST:LOG: statistics buffer is full
>
Since your server is in a heavy load, so the common trick is to i
Hi all.
There are two tables:
create table device_types (
id int,
name varchar
);
about 1000 rows
create table devices (
id int,
type int REFERENCES device_types(id),
name varchar,
data float
);
about 20 rows
And about 1000 functions:
create function device_type1(int) returns ..
create func
