On Sat, Jul 02, 2005 at 02:12:42PM +0100, Wojciech Sobczuk wrote:
> I have a very busy dual-RAID1 machine, doing tens up to hundreds of queries
> per second. After around 6 days of running at that kind of a load
> postgresql starts processing queries very very slowly (load jumps to 40 from
> 2) wh
On Mon, Nov 28, 2005 at 05:49:02PM +0100, Stefano Reksten wrote:
> Should not a char(10) insert 6 padding spaces? Or am I missing something
> like an update in the SQL standard?
char_length()
regards
--
Paweł Bernat; uselessness' lover;
select''as email;
Slowly and surely the unix crept up on th
On Mon, Nov 28, 2005 at 05:49:02PM +0100, Stefano Reksten wrote:
> Should not a char(10) insert 6 padding spaces? Or am I missing something
> like an update in the SQL standard?
Use char_length(string).
regards
--
Paweł Bernat; uselessness' lover;
select''as email;
Slowly and surely the unix cre
