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
/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)-
,
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,
--
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
19 matches
Mail list logo
