Abu Mushayeed <[EMAIL PROTECTED]> writes:
> I really could appreciate some help.
If nothing else, "set enable_hashagg = off" should help. But have you
analyzed these tables lately? Perhaps you have work_mem set too high?
regards, tom lane
---(end
On Tue, Oct 31, 2006 at 19:05:58 +0800,
nineday <[EMAIL PROTECTED]> wrote:
> I have a trouble.
> My DBMS is PostgreSQL which is accessory to Red hat 9.0.
> At the initial stages, it was very quick when select ,but operated for
> several months , it become to very slow ,especially in a pivotal ta
Without
knowing more details about what version of postgres and type of activities going
on,etc, it may be hard to figure out what's going out. However, one maintenance
operation that you want to make sure it happens to is to run
vacuum/analyze periodically so that expired tuples can be re-u
> Assuming that you are running Postgres on a linux system, you could do
> the following:
>
> 1) Create a partition with quotas enabled (via standard linux OS
> procedures). The postgres user is the user for which quotas should be
> enforced since postgresql always runs under the postgres uid.
>
On Mon, 2006-11-06 at 16:29 -0600, Nikola Radakovic wrote:
> Setting user's quota on my linux machine wont affect database
> quota.It will have impact on users directories.So, it must
> be a trick how to set PostgreSQL quota. Or how to link PostgreSQL
> database with directories which already have
On Mon, 2006-11-06 at 16:29, Nikola Radakovic wrote:
> Setting user's quota on my linux machine wont affect database
> quota.It will have impact on users directories.So, it must
> be a trick how to set PostgreSQL quota. Or how to link PostgreSQL
> database with directories which already have set qu
I really could appreciate some help. I tried to run the following query and I get the following dumpQuery:SELECT COUNT(*)/* cdc.cus_nbr, cdc.indiv_fkey, MAX( CAS
Setting user's quota on my linux machine wont affect database
quota.It will have impact on users directories.So, it must
be a trick how to set PostgreSQL quota. Or how to link PostgreSQL
database with directories which already have set quotas.
On Mon, 2006-11-06 at 16:52 -0500, Mike Goldner wro
> I appreciate your help, You don't understand me because my English is
> awful.
> I would try to paraphrase the sentence-maybe I succeed to correctly
> express myself.I want to limit database space for each database user on
> my system.For example, One user can hold one or more databases, but I
>
Nikola,
I'm not exactly sure what you are asking.
The size of the database is usually determined by the amount of data
stored and not determined beforehand.
Are you refering of "tablespaces", as other DBMSs use them? If so,
Postgres has a tablespace command, but it simply points to a filesy
> I would be very grateful if someone could answer me,
> where to find instructions how to set the size ( in megabytes ) for
> particular database.
I don't understand the question, are you looking to limit the size of your
database?
Regards,
Richard Broersma Jr.
---(e
select pg_database_size('')/1024/1024;http://www.postgresql.org/docs/8.1/interactive/functions-admin.html
On 11/6/06, Nikola Radakovic <[EMAIL PROTECTED]> wrote:
Dear community,I would be very grateful if someone could answer me,where to find instructions how to set the size ( in megabytes ) forpar
Dear community,
I would be very grateful if someone could answer me,
where to find instructions how to set the size ( in megabytes ) for
particular database.
best regards,
N.Radakovic
---(end of broadcast)---
TIP 1: if posting/reading through Us
I am trying to run the following query
SELECT
cdc.cus_nbr,
cdc.indiv_fkey,
MAX(
CASE
WHEN UPPER(pay.pay_typ) IN
('B','G','I','L','R','X','Y') THEN 'Y'
WHEN pay.pay_typ IN
('0','1','2','3','4','5','6','7','8','9')
> My name is Diego, I am a Brazilian student, and I would know if there
> is some version of PostgreSQL with features to work with distributed
> database management.
> Where I may to find some document about this functions?
>
> Thanks for attention
I do not believe that the standard package of Po
You need to vacum (probably re-index) your tables
periodically to get the best performance.
These vacuming and indexing tools should already
be there with your PostgreSQL installation.
--Imad
www.EnterpriseDB.com
On 10/31/06, nineday <[EMAIL PROTECTED]> wrote:
I have a trouble.
My DBMS is Pos
I installed the PostgreSQL tools for Mac from the sourceforge site
(8.1.5). The server and client tools installed fine and the server is
running and accessible. However, it doesn't appear that the language
libraries got installed, as I can't install plpgsql. I get:
could not access file "$libdir/p
Hello,
My name is Diego, I am a Brazilian student, and I would know if there
is some version of PostgreSQL with features to work with distributed
database management.
Where I may to find some document about this functions?
Thanks for attention
Diego
---(end of broadcast
I have a trouble.My DBMS is PostgreSQL which is accessory to Red hat 9.0.
At the initial stages, it was very quick when select ,but operated for several months , it become to very slow ,especially in a pivotal table.So,I exported data ,and recreate tables , finally import data, it get right .
Dear community,
First of all, I am completely new on this mailing list.
I have read tons of tutorials, but I can't find how to set up
further thing.I know how to add database for each user, but how to
achieve in Postgres 8.1 how big assigned database should be on server
machine?
For instance:
I
Hi,
My postgresql configuration is
max_locks_per_transaction = 256
max_connections = 200
shared_buffers = 6000
max_fsm_pages = 20
max_fsm_relations = 1500
My serversers total RAM=32GB
Still I am not able to insert more than 10million records, its
taking lot of time. I
21 matches
Mail list logo
