I use this script to create the database:
DROP DATABASE tei;
CREATE DATABASE tei
WITH ENCODING='iso_8859_7'
OWNER=anakreon
TEMPLATE=template1
The encoding of the database is iso_8859_7.
--
Three words describe our society:homo homini lupus
---(end of broadcast)
On Sun, 5 Mar 2006 00:34:46 -0700
Brendan Duddridge <[EMAIL PROTECTED]> wrote:
> Hi,
>
> We're running PostgreSQL 8.1.3 on an Intel iMac at work and I also
> have it running just fine on my new MacBook Pro. No problems.
> Compiled as is out of the box using the instructions at http://
> keyva
Thanks, it's a good idea.
Someone can help me with the two others question (the index and the
update of the structure of the table) ?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an ind
hi,
i want to fully understand the functioning of postgres indexes with
respect to the code.
where can i find help regarding this ? any detailed manuals available ??
--
IYENGAR SURESH P.
MTECH 1 , IIT BOMBAY HOSTEL 8 ,
---(end of broadcast)--
I have spent some time looking around for the documents in
Spanish, and am having no luck. Does anyone know if there are any?
Thanks!
===
He pasado una cierta hora que miraba alrededor para los
documentos en español, y la que no tenía ninguna suerte. He pedido una cierta
ayuda de
On Sun, 2006-03-05 at 08:50 +0530, IYENGAR SURESH PARTHASARATHY wrote:
> i want to fully understand the functioning of postgres indexes with
> respect to the code.
See src/backend/access/ in the source tree, specifically the nbtree/,
hash/, gist/ and index/ subdirectories -- each directory has a
Is your table really over 100G?
Yeap 600+ million rows.
Anyway, if the block size is 8192
then 902292 sould be in the .6 file. If you can spare the time
then you might run the dd and od commands that Tom Lane mentions
in the above message and post the output.
Here's the output:
000 0
On Mon, Mar 06, 2006 at 11:57:53AM +1100, Noel Faux wrote:
> >Anyway, if the block size is 8192
> >then 902292 sould be in the .6 file. If you can spare the time
> >then you might run the dd and od commands that Tom Lane mentions
> >in the above message and post the output.
> Here's the output:
