Objects under the View menu [2]. Based on my assumptions, I
guess it's the TOAST of the field which contains the body of your emails...
Enough wild guesses,
HTH,
--
MaXX
[1] hidden: transparent from an user point of view
[2] you can also obtain those information from the information schema IIRC
: 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)---
TIP 2: Don't
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,
--
MaXX
---(end
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 column's datatypes do
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 MODEOWNERGROUPCREATOR
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
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
single normal
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 ICMP
)...
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 to the mailing
.
Thanks,
--
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 to the mailing list cleanly
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 runs almost 10x faster than:
SELECT stats_put_sources
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 desire to
choose
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
---(end of broadcast
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 the table
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 content...
Right?
You have
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...
Right?
Not really. It's more like
the actual
checking)
HTH,
--
MaXX
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
but I'm reviewing my regexps just in case...
--
MaXX
---(end of broadcast)---
TIP 6: explain analyze is your friend
18 matches
Mail list logo
