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 16M rows this query:
SELECT adv, pub, web, country,
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
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
-
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] Index use in BETWEEN statement...
On 9/26/05 11:26 AM, Cristian Prieto [EMAIL PROTECTED] wrote
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
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?
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!