2. How to determine what data is containing in pg_toast_22185 ?
If you have PGAdmin at hand or you can install it, its quite easy, just enable
"Show System Objects" under the "View" menu [2]. Based on my assumptions, I
guess it's the TOAST of the field which contains the
a transaction"
(#: access/transam/xact.c:510)
HTH,
--
MaXX
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
inside stored procedures as the injection can take place before the actual
checking)
HTH,
--
MaXX
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
opefully the given examples work with
MySQL but I'm reviewing my regexps just in case...
--
MaXX
---(end of broadcast)---
TIP 6: explain analyze is your friend
once the main script has collected
them, this takes between 1 and 30min), then another script vacuums the
table and aggregate the last imported rows, if I add a column with the
commit timestamp and cluster on it, will I gain some perfs or not?
Thanks,
--
MaXX
more like the table
of content...
Right?
Thanks again,
MaXX
Jim C. Nasby wrote:
> The key expense in doing an index scan is the amount of randomness
> involved in reading the base table. If a table is in the same order as
> the index then reading the base table will be very fast. If
Jim C. Nasby wrote:
> On Wed, Nov 02, 2005 at 08:50:45PM +0100, MaXX wrote:
[...]
>> In simple words:
>> Clustered indexes are like the alphabetical index in a book, where term
>> are randomly distibuted in the book and regular indexes are more like the
>> table of cont
Scott Marlowe wrote:
> On Wed, 2005-11-02 at 13:50, MaXX wrote:
[...]
>> In simple words:
>> Clustered indexes are like the alphabetical index in a book, where term
>> are randomly distibuted in the book and regular indexes are more like the
>> table of content...
&g
tryied to move a row without freeing the destination first... I
added a new column and changed my "order by" to match its name.
If this can help,
--
MaXX
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your
put_source(varchar,varchar,int4,int4) function is a rewrite
of the INSERT OR UPDATE function described in the docs.
Thanks,
--
MaXX
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comm
Tom Lane wrote:
> MaXX <[EMAIL PROTECTED]> writes:
>> Can this be the cause of a huge loss of perf? I have the following query
>> in a Perl script using DBI + DBD::Pg, AutoCommit => 0:
>> SELECT stats_put_sources(?, ?, int4(?), int4(?))
>> This syntax ru
192.168.0.250(50624)
idle (postgres)
80724 ?? I 0:01.67 postmaster: pgsql ipfw 192.168.0.250(60737)
idle (postgres)
81216 ?? I 0:00.48 postmaster: perl ipfw [local] idle (postgres)
81253 ?? I 0:01.43 postmaster: webpguser ipfw [local] idle (postgres)
HTH,
--
MaXX
it is the Nvidia module... I have an nvidia kernel module loaded
on my FreeBSD 6.1 laptop and I also have that root owned world writable
stuff.
From my laptop (sorry for the line wrap):
[EMAIL PROTECTED]:/home/maxx #ipcs -a
Shared Memory:
T ID KEY MODEOWNER
ning or use an idependant script,
while [ 1 ]
do
vacuum --all
sleep 60
done
[...]
HTH,
--
MaXX
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining
,
thus breaking your file.
A more robust workaround is using output buffering to clear any unwanted output
before sending the file...
I have no problem storing bytea objects and retreiving them. Using output
buffering allows you to use ob_gzhandler to reduce network bandwith if
needed...
HTH,
--
/dataInsert.php on line 9,
> referer: http://localhost/some_dir/some_dir/dataEnter.php
Did you upgrade database/php4-pgsql too?
I think you just have to rebuild it in order to fix the dependencies with
database/postrgresql82-client...
HTH,
--
MaXX
---(end of broadcast)-
is not uniform)...
Is this correct?
Thanks a lot,
--
MaXX
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through
Gregory Stark wrote:
MaXX <[EMAIL PROTECTED]> writes:
In my understanding, a partial index is only touched when a matching row is
inserted/updated/deleted (index constraint is true), so if I create a partial
index for each protocol, I will slow down my machine as if I had created a
Jeff Davis wrote:
On Tue, 2006-08-15 at 13:13 +0200, MaXX wrote:
[snip]
I have a table in which I store log from my firewall.
For the protocol column (3 distinct values: TCP ~82%, UDP ~17%, ICMP
~1%, the table contains 1.7M rows), I use a partial index to find ICMP
packets faster.
It's
19 matches
Mail list logo
