I suspect that my manualy vacuum every 10 days or so really wasn't nearly enough ;)AlexOn 6/9/06, Jim C. Nasby <
[EMAIL PROTECTED]> wrote:This tells me that you need to be vacuuming more. Autovac is your
friend.On Thu, Jun 08, 2006 at 07:14:01PM -0400, Alex Turner wrote:> Yeah - I just did a reinde
"Rojas, Fernando \(CIAT\)" <[EMAIL PROTECTED]> writes:
> But when I locale - a the result is:
> ...
> en_US.utf8
> ...
You probably need to spell it exactly like that, not "en_US.UTF-8".
No, I don't have any idea why it worked before, if you're using the
exact same OS release ... maybe you're miss
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Actually, it's BLCKSZ/4. From
> http://www.postgresql.org/docs/8.1/interactive/storage-toast.html:
> "The TOAST code is triggered only when a row value to be stored in a
> table is wider than BLCKSZ/4 bytes (normally 2Kb)."
> BTW, 'row value' seems a b
On Sat, Jun 10, 2006 at 06:37:35PM -0400, Terry Lee Tucker wrote:
> On Saturday 10 June 2006 06:31 pm, "Yavuz Kavus" <[EMAIL PROTECTED]> thus
> communicated:
> --> i am writing a recursive procedure in pl/pgsql.
> --> i need to check whether a condition is true in any step of recursive
> calls. -
On Sat, Jun 10, 2006 at 05:10:06PM -0400, Christopher Browne wrote:
> Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (list_man) would
> write:
> > Can someone tell me if I have to 'enable' TOAST on columns to have it
> > kick in. According to my research, numeric data types are toastab
On Saturday 10 June 2006 06:31 pm, "Yavuz Kavus" <[EMAIL PROTECTED]> thus
communicated:
--> i am writing a recursive procedure in pl/pgsql.
--> i need to check whether a condition is true in any step of recursive
calls. -->
--> if i get a true response in one call, i wont make other recursive cal
i am writing a recursive procedure in pl/pgsql.i need to check whether a condition is true in any step of recursive calls.if i get a true response in one call, i wont make other recursive calls anymore, because i get what i need.
if no one gives me a true response, then uppest procedure will return
After a long battle with technology, [EMAIL PROTECTED] (list_man), an
earthling, wrote:
> Hi,
>
> I wonder if anyone can help.
>
> I have a VERY wide table and rows. There are over 800 columns of type:
> numeric(11,2)
>
> I can create the table no problem, but when I go to fill out a full row
> wi
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (list_man) would
write:
> Can someone tell me if I have to 'enable' TOAST on columns to have it
> kick in. According to my research, numeric data types are toastable.
TOAST is only used on individual columns that exceed 8K in size.
The o
On Saturday 10 June 2006 13:30, "Pat Maddox" <[EMAIL PROTECTED]> wrote:
> I've got a table with that has 5 fields. Nearly every query I make to
> this table is of the form
> SELECT * FROM table1 WHERE field1='foo' AND field2=7;
>
> It's always those two exact fields. How should I index this to ge
On Sat, 2006-06-10 at 14:06 -0400, Tom Lane wrote:
> John Gray <[EMAIL PROTECTED]> writes:
> > This is the reason why xpath_table allows you to specify an
> > identifying field (usually a primary key but doesn't have to be)- the
> > solution to your question is to join an xpath_table that just fet
I've got a table with that has 5 fields. Nearly every query I make to
this table is of the form
SELECT * FROM table1 WHERE field1='foo' AND field2=7;
It's always those two exact fields. How should I index this to get
the best performance?
Also, how can I find what other parts of my app would b
am 10.06.2006, um 14:09:36 -0500 mailte Adam folgendes:
> I tried searching for this but didn't see anything.
>
> Is there a way I can see the last 5 or last 1 SQL statements that have been
> run on the server? I'm using 8.1.3 ---(end of
'log_statement = all'
in your
I tried searching for this but didn't see anything.
Is there a way I can see the last 5 or last 1 SQL statements that have been
run on the server? I'm using 8.1.3
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi,
I wonder if anyone can help.
I have a VERY wide table and rows. There are over 800 columns of type:
numeric(11,2)
I can create the table no problem, but when I go to fill out a full row
with data, I get the message about reaching the 8k limit.
Can someone tell me if I have to 'enable' TOAST
Bjørn T Johansen wrote:
> Yes, that is annoying But you can remove the legend by right clicking on
> the name of
> the ER and choosing Properties.. Under Legend, you can change Location to
> None;
> that will remove it...
Thanks Bjorn. I'll give that a try. Hopefully that will be turned off
Thanks for the help, guys. I've learned from this the importance of keeping a
journal of software installation.
Jonathon McKitrick
--
My other computer is your Windows box.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Database is running on Windows 2003 Advanced Server and it is PostgreSQL 8.1.3.The Java application is running from a remote machine running Windows XP Professional SP2.On 6/9/06,
Tom Lane <[EMAIL PROTECTED]> wrote:
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:> A wild guess is that when we continue
Lots of great conversation here. Thanks to all for participating.
David, you wrote:
>Be aware that Pascal, along with Date and Darwen, are...how do I put
>this gently...cranks. They've been getting more strident and
>irrational as the decades go by.
I can't speak to that statement directly. Indi
HELLO:
I have now an error similar to one posted under the subject:
We had format the DISK and reinstall the SO (Red Hat Linux 8.0 3.2-7); we don't
have a pg_dumpall file of support; but we have
The copy of the data file that was running ok under (PG-8.0.7).
We reinstall P.G 8.0.7 and try to st
John Gray <[EMAIL PROTECTED]> writes:
> This is the reason why xpath_table allows you to specify an
> identifying field (usually a primary key but doesn't have to be)- the
> solution to your question is to join an xpath_table that just fetches the
> document number against the primary key, e.g.:
Thanks for the suggestion Tom... I'm looking into it.
To continue however and educate me on datatypes & TOAST, should a row of
10k+, in this case consisting of the datatype listed below, store OK,
when TOAST kicks in?
thanks... Angus
On Sat, 2006-06-10 at 12:28 -0400, Tom Lane wrote:
> list_man
list_man <[EMAIL PROTECTED]> writes:
> I have a VERY wide table and rows. There are over 800 columns of type:
> numeric(11,2)
Perhaps you should reconsider your data design. Maybe some of those
columns would more logically form an array?
regards, tom lane
---
Hi,
I wonder if anyone can help.
I have a VERY wide table and rows. There are over 800 columns of type:
numeric(11,2)
I can create the table no problem, but when I go to fill out a full row
with data, I get the message about reaching the 8k limit.
Can someone tell me if I have to 'enable' TOAS
[EMAIL PROTECTED] wrote:
I wrote about this, but I lost the thread.
Today I did clean install in a new virtual machine of FreeBSD 5.4,
Apache 1.3.36, php 5.1.4 and PostgreSQL 8.1.4 from ports - and apache
did core dump again.
Commenting pgsql.so in the php extensions solves the problem, but
Em Sábado 10 Junho 2006 05:31, Adam Witney escreveu:
> yep it is there, when i display the data from the application (PHP) it
> shows the character on the web page. Also this causes errors when i dump
> from 7.4 and try to load into 8.1 (i've read that the UNICODE checking
> became more stringent i
Martijn van Oosterhout wrote:
> On Fri, Jun 09, 2006 at 04:32:35PM +0100, Adam Witney wrote:
>>> The database will do it for you. Note that the client encoding affects
>>> input *and* output. So if you set it to latin1, the database will
>>> convert all strings to latin1 before sending them to yo
27 matches
Mail list logo
