[EMAIL PROTECTED] ~/postgresql-8.2beta1]$ ./configure --enable-debug
--with-cassert
checking build system type... i386-pc-solaris2.10
checking host system type... i386-pc-solaris2.10
checking which template to use... solaris
checking whether to build with 64-bit integer date/time support... no
Alvaro Herrera wrote:
On Wed, Jun 30, 2004 at 10:56:53PM -0400, Joseph Shraibman wrote:
Seeing how small storage for a number type is compared to a text type,
and seeing how they tend to be queried on a lot, shouldn't it be
reasonable for the default stats number for numerics to be 100 instead
Seeing how small storage for a number type is compared to a text type,
and seeing how they tend to be queried on a lot, shouldn't it be
reasonable for the default stats number for numerics to be 100 instead
of 10?
---(end of broadcast)---
TIP 6:
Is anyone working on these two todo items?
# CLUSTER
* Automatically maintain clustering on a table
* Add way to remove cluster specification on a table
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL
Bruce Momjian wrote:
Joseph Shraibman wrote:
* Add way to remove cluster specification on a table
This patch is done and will be applied soon.
I'm a bit confused, why would you want to uncluster a table?
---(end of broadcast)---
TIP 6: Have
Bruce Momjian wrote:
Because a CLUSTER with no argument clusters all previously clustered
tables in the db. This turns it off for that table.
My bad, I should have read the docs more closely.
---(end of broadcast)---
TIP 6: Have you searched our
Joseph Shraibman wrote:
Joseph Shraibman wrote:
After further experimenting I think the problem is in psql. When I try
update mytable set firstname = 'Oné' where ukey = 12911;
It works with a latin1 database, but when I try it on a unicode database:
utfowl=# update mytable set firstname = 'Oné
that locks all the files, quickly tars them up, then
releases the lock?
--
Joseph Shraibman
[EMAIL PROTECTED]
Increase signal to noise ratio. http://www.targabot.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send
[EMAIL PROTECTED] wrote:
Can PostgreSQL 7.1 store java classes or objects?
Sure it can, but not automatically. just serialize your object to a
byte array and store that String.
--
Joseph Shraibman
[EMAIL PROTECTED]
Increase signal to noise ratio. http://www.targabot.com