-- Forwarded message --
From: jose fuenmayor <[EMAIL PROTECTED]>
Date: Apr 28, 2007 1:02 PM
Subject: File systems linux !!!
To: [EMAIL PROTECTED]
Hi all, i need to install a database in postgres with high reading rates,
which is the best file system to do that , I am work
Thanks for your answer!How can i issue a cancel?
thanks in advance!On 11/10/06, Simon Riggs <[EMAIL PROTECTED]> wrote:
On Thu, 2006-11-09 at 19:54 +, jose fuenmayor wrote:> Hi all , I have a question or a doubt, when I ran psql remotely it> opens a process on the server, so I i
ib Mir
EnterpriseDB (www.enterprisedb.com)On 11/10/06,
jose fuenmayor <[EMAIL PROTECTED]
> wrote:Hi thanks for the answer, but
Is not when the query is executed ,is when the user cancells the query
or kill the client that he is using when this query has not finished,
then the process in t
Hi all , I have a question or a doubt, when I ran psql remotely it
opens a process on the server, so I issue a query (select count(*) from
80millionsrowstable) then I can see that process taking cpu and mem
from the server (using top), then I cancel the psql on the client, I
expect to see that proc
Hi all, I been having a weird problem with the postgresql odbc driver,
I am working on an aplication in ms visual fox pro which use to have a
database in MS SQL Server I am migrating it to postgres, the problem
with the driver is that when I put the user name and password, the
driver gives me an er
How can I install pg_xlog (WAL) in another partition, i mean separate
the data directory from WAL, i have a single scsi disk with four
partitions
/, /boot, /data(data for postgresql), /WAL(pg_xlog), i ve heard that by
doing this occurs a boost in postgreSQL performance, thanks in advance
anyone tha
i waited like 11 hours and it doesn't finish, where is the FSM setting postgreSQL.conf?On 8/30/05, Bruno Wolff III <
[EMAIL PROTECTED]> wrote:On Tue, Aug 30, 2005 at 08:38:03 -0400, jose fuenmayor <
[EMAIL PROTECTED]> wrote:> i am using postgreSql 8.0.3 i've try vacu
o ?On 8/25/05, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
On Thu, Aug 25, 2005 at 08:52:35 -0400, jose fuenmayor <[EMAIL PROTECTED]> wrote:>> The size of the table is 3 times bigger than, for instance Visual Fox> Pro dbf's? since is there fisically three times.
Have you b
I read and have seen that when a table has more than 1GB it is divided
in several files with the names of inode,inode.1,inode.2,inode.3, etc.
I have a table of 1.3 GB (9.618.118 rows,13 fields) it is divided in
that way as i see on /PGDATA/base but each file has the same size i
mean
table inode (
the first page is generally reserved as a metapage holding
> control information, and there may be different types of pages within
> the index, depending on the index access method. [...]
>
> Source-URL:
> http://www.postgresql.org/docs/8.0/interactive/storage-page-layout.html
>
> j
-- Forwarded message --
From: jose fuenmayor <[EMAIL PROTECTED]>
Date: Aug 22, 2005 1:37 PM
Subject: Indexes (Disk space)
To: pgsql-admin@postgresql.org
Hi all,
I have the following question.
Is there anyway for me to know how much space on disk will ocupy an
index, create
Hi all,
I have the following question.
Is there anyway for me to know how much space on disk will ocupy an
index, created in a determined row or rows of a table?, anything like
a rule, formula, calculation? that allow me to know in advance how
much space will the index use before actually created
Hi all,
I need to add a new disk to the data directory of postrgreSql ( the
one i ve got is running out of space), how can i do that?, i have
postgreSql 8.0.3 on a Mandrake Linux 10.1 machine (hp proliant ml350
g3)
Do I have to use LVM (Logical Volume Manager)?
Is there any workaround in postgre
Hi good afternoon everyone, my name is Jose Antonio Fuenmayor Nava, I
am Venezuelan, I work as a Systems Analist in Reingenieria y Sistemas
C.A, that´s a company that operates in Maracaibo, Venezuela, this
company manages huges amounts of data, yesterday i was trying Pgadmin
3, I performed the foll
14 matches
Mail list logo