On Wed, Apr 26, 2006 at 07:30:49PM -0600, Benjamin Krajmalnik wrote:
> I am about to take a system from testing into production.
>
> The system is a combination oltp/bi (network monitoring platform).
>
> We are currently inserting about 1 million rows per day, and will
> increase to probably 5 mi
I am about to take a system from testing into production.
The system is a combination oltp/bi (network monitoring
platform).
We are currently inserting about 1 million rows per day, and
will increase to probably 5 million once it goes into full deployment.
The current test production ser
Title: Re: [ADMIN] Table partitioning
I do not have remote access
right now via psql.
from pgAdmin, the table definition is as
follows:
CREATE TABLE tblksraw( devicename varchar(50) NOT
NULL, accountno int8 NOT NULL, testtime timestamp NOT
NULL, replytxt varchar(1024), replyval flo
ok
thanks
On Wed, 2006-04-26 at 19:22 -0400, Tom Lane wrote:
> Warren Little <[EMAIL PROTECTED]> writes:
> > which appears to be the pg_toast entry. Shouldn't there be a pg_class
> > whose reltoastrelid equals the reltoastidxid of the pg_toast instance
>
> No. The deal is
>
> regular table's
Warren Little <[EMAIL PROTECTED]> writes:
> which appears to be the pg_toast entry. Shouldn't there be a pg_class
> whose reltoastrelid equals the reltoastidxid of the pg_toast instance
No. The deal is
regular table's reltoastrelid points to OID of its toast table
toast table's reltoastidxid p
Can we see the output of \d tablename as well as EXPLAIN ANALYZE of the
select?
On Wed, Apr 26, 2006 at 02:48:50PM -0600, Benjamin Krajmalnik wrote:
> Actually, right now there is no data in those partitions.
>
> All of the data is currently in the parent table (I have not yet created
> the trigg
On Wed, Apr 26, 2006 at 04:33:04PM -0400, Chris Hoover wrote:
> Each of the partition tables needs it's own set of indexes. Build them, and
> see if the does not fix your performance issues. Also, be sure you turned
> on the constraint_exclusion parameter, and each table (other than the
> "master
On Tue, Apr 25, 2006 at 04:47:53PM -0500, Jason Minion wrote:
> Usually a dump is significantly smaller than a live database due to
> space taken up by indexes and discarded tuples from MVCC. If it's
> significantly smaller you may also want to take a look at your vacuuming
> procedure.
Between ex
Hello,
got myself in a pickle with the database running out of space.
I have a question regarding pg_toast tables and their relationships to
the parent tables.
If I run the following query
select * from pg_class where
reltoastrelid like '%944' or reltoastidxid like '%944'
I receive a single row
REMOVE LIST pgsql-admin@postgresql.org
Gracias.
César Maldonado S.
Ing. Informática y Gestión (a)
E-Mail: [EMAIL PROTECTED]
###
Este mensaje ha sido revisado por el scanner antivirus del Ministerio de
Economia.
Actually, right now there is no data in
those partitions.
All of the data is currently in the parent
table (I have not yet created the trigger which will route the data to the
correct partition).
I just found to items intriguing –
first, that the indices and other properties other than th
you should use the PG 8.1 pg_dump to dump the 7.4.3 database and then import it into the new server. It is not recommended to do it the way you have done it.On 4/25/06,
Uwe Maiwald <[EMAIL PROTECTED]> wrote:
Hi,i get the following warning from pg_restore and would like to know if i cansafely igno
On 26 Apr 2006 12:39:26 -0400, Jerry Sievers <[EMAIL PROTECTED]> wrote:
Pgadmins, 2 loosly related questions1. We have need to let developers view the postmaster logs on some of our environments and wish NOT to give them access to the postgres Unix acct if possible. It looks though as if log f
Each of the partition tables needs it's own set of indexes. Build them, and see if the does not fix your performance issues. Also, be sure you turned on the constraint_exclusion parameter, and each table (other than the "master") has an constraint on it that is unique.
HTH,Chris
On 4/26/06, Prasanth <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Seems like by default database is created using UTF-8 when we use
> createdb in 8.1.3.
>
> Is there any big advantage of using UTF-8 rather than ASCII? Will there
> be any performance difference when performing string operations?
>
> Does th
Hi,
Seems like by default database is created using UTF-8 when we use
createdb in 8.1.3.
Is there any big advantage of using UTF-8 rather than ASCII? Will there
be any performance difference when performing string operations?
Does the string functions convert every thing to UTF-8 before performi
I have created a parent table and inherited into several
tables to facilitate table partitioning.
I noticed that the inherited tables did not inherit any of
the indices, etc. in their DDL.
Do these need to be created, or are they actually there via
inheritance but only “used” when the par
Pgadmins, 2 loosly related questions
1. We have need to let developers view the postmaster logs on some of
our environments and wish NOT to give them access to the postgres
Unix acct if possible. It looks though as if log file perms are
determined by the global umask set in postmaster.c
I did the following and it worked.
1. Did a text pg_dump and used iconv to remove invalid characters and then
loaded this into the database.
2. Took a dump created using -Fc and restored just the pg_largeobject table.
Every thing seems to be good.
I don't see the -b option in pg_dump in 8.1.3 so
On Apr 26, 2006, at 6:46 AM, sandhya wrote:
I have loaded all my files into the database.Files has to open like
( html,asp,js,gif etc pages) from the database via a
webserver.Please explain me whether there will be any problem if i
open .asp ,.gif files from the DB.
How to know whether the
I found a solution: I re-run initdb with Unicode encoding and now seems to work fine.
I cannot figure out why did this happen, or does
the initdb encoding affects all the databases or the db encoding is not enough
to be specified?
Andy.
- Original Message -
From:
Andy
Hi,
I have loaded all my files into the database.Files has to
open like( html,asp,js,gif etc pages) from the database via a
webserver.Please explain me whether there will be any
problem if i open .asp ,.gif files from the DB.
How to know whether the files what we have loaded into the
datab
22 matches
Mail list logo
