Hi all!
Can I restrict max number of connections from one IP address?
--
Thanks
Nic
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
V
My query is
select EXTRACT(MONTH FROM M.fecha) as ho,count(*) as tot from correo M
where EXTRACT(YEAR FROM M.fecha)='2004' group by EXTRACT(MONTH FROM
M.fecha);
When I executed a EXPLAIN ANALIZE, I hace the following Answer
Aggregate (cost=122439.31..122558.36 rows=2381 width=4) (actual
time
--- Vida Luz <[EMAIL PROTECTED]> escribió:
> Hi all
>
> I have a table in y database that have 8,000,000 of
> rows, when I execut a
> query on this table, the answuer is very slow.
>
> I have a index in this table by datem, my table is
>
> Column | Type| Modifiers
> -
Hi all
I have a table in y database that have 8,000,000 of rows, when I execut a
query on this table, the answuer is very slow.
I have a index in this table by datem, my table is
Column | Type| Modifiers
-+---+---
nombre | charac
On Fri, Nov 12, 2004 at 10:30:27AM -0500, Paul B. Anderson wrote:
> When the vacuum full timed out, could the exclusive lock have been left
> set, leaving the database in an unusable state?
No, but cancelling a VACUUM FULL takes a long time, in my experience,
and so the lock hangs around for quit
When the vacuum full timed out, could the
exclusive lock have been left set, leaving the database in an unusable
state?
BTW, thanks. I removed the --full option.
Paul
Andrew Sullivan wrote:
On Thu, Nov 11, 2004 at 05:14:50PM -0500, Paul B. Anderson wrote:
/usr/bin/vacuumdb
On Thu, Nov 11, 2004 at 05:14:50PM -0500, Paul B. Anderson wrote:
>
> /usr/bin/vacuumdb --all --full --analyze
^
You do realise that takes an exclusive lock, right? Why are you
doing VACUUM FULL? If your FSM is set right, you really shouldn't
need it for most ca
Hello everybody,
I'm working with a monitoring tool for Grid enviroments. The thing is
that, this tool (GridICE) works uses a PosgreSQL Database. I get an
error at this part of the code:
$siteName = $_GET["siteName"];
$V
