I have the following table:
CREATE TABLE mytmp (
Adv
integer,
Pub
integer,
Web
integer,
Tiempo
timestamp,
Num
integer,
Country
varchar(2)
);
CREATE INDEX idx_mytmp ON mytmp(adv, pub, web);
And with 16
Hi, I just have a little question, does PgPool keeps the same session
between different connections? I say it cuz I have a server with the
following specifications:
P4 3.2 ghz
80 gig sata drives x 2
1 gb ram
5 ips
1200 gb bandwidth
100 mbit/s port speed.
I am running a PgSQL 8.1 server with 100 m
There any performance differences between a SQL function written in SQL
language or PL/psSQL language? For example:
Create or replace function sp_getfreq(
Var1 integer
) returns Boolean as
$$
Declare
Myval Boolean;
Begin
Select var1 in (select var3 from table1) into myval;
Hello, just a little question, It's preferable to use Text Fields or
varchar(255) fields in a table? Are there any performance differences in the
use of any of them?
Thanks a lot for your answer!
---(end of broadcast)---
TIP 4: Have you searched ou
g a sequential scan in the table and ignores the
index, any other suggestion?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sean Davis
Sent: Lunes, 26 de Septiembre de 2005 10:24 a.m.
To: Cristian Prieto; pgsql-general@postgresql.org
Subject: Re: [GENERAL]
Hello pals, I have the following table in Postgresql 8.0.1
Mydb# \d geoip_block
Table "public.geoip_block"
Column| Type | Modifiers
-++---
locid | bigint |
start_block | inet |
end_block | inet |
mydb# explain analyze select locid from geoip_blo
Hi, I've reading around there about some way to
help pgsql with the data caching using memcached inside the sps in the database
(not in the application), does anybody have success with that?
Thanks a lot!
I know you almost had read this, but I think it is
a good paper to start with...
http://lca2005.linux.org.au/Papers/Neil%20Conway/Inside%20the%20PostgreSQL%20Query%20Optimizer/pg_query_optimizer.pdf
Anyway, do you know where could I get more info and
theory about database optimizer plan?
