Archiwizowane October, 2007

October 29th, 2007 by depesz | | No comments »

i'm not really "there" yet, but soon, their faith might be mine :) glasbergen is the best :)

October 28th, 2007 by depesz | Tags: | 9 comments »

edit: title was changed because apparently it was too offensive the title might a bit too offensive, but perhaps it will make it more visible. some time ago (march 2007) i asked on polish db-related newsgroup about things that people hate about ...

October 27th, 2007 by depesz | | No comments »

zapraszam na nowo-otwarty blog motoryzacyjny auta.cc.

October 26th, 2007 by depesz | Tags: | 10 comments »

so, there you have a users table, with a very basic structure: Table "public.users" Column | Type | Modifiers -----------+---------+----------- id | integer ...

October 22nd, 2007 by depesz | | 4 comments »

nice machine with 2 gb of ram, 800 megabytes in 2 logfiles. single word as search phrase. polish utf-8 locale (pl_PL.UTF-8), gnu grep 2.5.1. results? => time grep -in reloading postgresql-2007-10-22_000000.log postgresql-2007-10-22_120909.log postgresql-2007-10-22_000000.log:40001:2007-10-22 10:50:13.528 CEST @ 24681 LOG: received SIGHUP, ...

October 19th, 2007 by depesz | Tags: , | 17 comments »

one of the more common problems new users have with postgresql (especially those that came from mysql background), is the lack of easy way to grant/revoke/do-something with many objects (tables/sequences/views) at once. there are number of pages that deal with the ...

October 19th, 2007 by depesz | Tags: | No comments »

Changes: get connection settings from command line: ./find.best.tablespace.split.pl "dbi:Pg:dbname=depesz;host=127.0.0.1;port=12345" depesz calculate only for public schema (can be easily changed) distribute indexes as well - always put indexes on another tablespace than table add comment in generated file about total filesizes in tablespaces ...

October 12th, 2007 by depesz | Tags: | 7 comments »

let's assume we have a simple table: Table "public.test" Column | Type | Modifiers --------+---------+----------- a | integer | not null b | integer ...

October 5th, 2007 by depesz | Tags: | 2 comments »

Changes: doesn't use temp files - does everything in-memory. makes the whole process *way* faster allow setting header information using postgresql log_line_prefix syntax removes dependency on readonly perl module - it is not really common module, and the functionality in this program is ...

UPDATE (2012-06-24): Version 9.1 of PostgreSQL renamed ident to peer (for local connections). So if you're having errors about "Peer authentication failed" - it is the same as "Ident authentication failed", and all described in this blogpost is still relevant. ever ...