First of all, Thanks for response, answers below.
On Mon, Jul 15, 2013 at 4:12 PM, Kevin Grittner kgri...@ymail.com wrote:
Rafael Domiciano rafael.domici...@gmail.com wrote:
PostgreSQL 9.2.2 on x86_64-unknown-linux-gnu, compiled by gcc
(GCC) 4.4.6 20120305 (Red Hat 4.4.6-4), 64-bit
Hello all you guys,
I've sent the same problem in performance list. Some answered me, but
didn't resolved the situation.
Since 2 weeks I'm get stucked in a very strange situation: from time to
time (sometimes with intervals less than 10 minutes), the server get
stucked/hang (I dont know how to
Hello,
What i have to do to remove the following post:
http://archives.postgresql.org/pgsql-admin/2009-09/msg00141.php
Thnks,
Rafael
Hello,
I Think you can this kind of information at pg_proc.prosrc
Best Regardas,
Rafael Domiciano
On Fri, Oct 2, 2009 at 3:57 AM, Julius Tuskenis jul...@nsoft.lt wrote:
Hello, everybody
I tried to find where in pg_catalog stored functions are stored, but with
no success
the pg_hba.conf is ok.
Has anyone get the same trouble? Helps?
Best Regards,
Rafael Domiciano
Hello People,
I upgraded to a 64 bits System. Now, everything is OK. Thnk you guys.
On Sat, Jul 11, 2009 at 2:19 AM, Scott Marlowe scott.marl...@gmail.comwrote:
On Fri, Jul 10, 2009 at 10:27 PM, sriram.dandap...@bt.com wrote:
2G per process is plenty ...and useful if you have large data
Thnks for the replyies.
It's a slony slave db, for reporting.
So, what's a good value to set to effective_cache_size with 10 Gb RAM?
On Thu, Jul 9, 2009 at 9:05 PM, Scott Mead scott.li...@enterprisedb.comwrote:
On Thu, Jul 9, 2009 at 6:18 PM, Rafael Domiciano
rafael.domici...@gmail.com
();
version
---
PostgreSQL 8.3.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.0
20080428 (Red Hat 4.3.0-8)
(1 row)
Thnks,
Rafael Domiciano
a Design Problem level, but don't,
new_column have to belong to table1, in this especific case.
Thks for response,
Rafael Domiciano
this:
update table1
set new_column = (date)
where
new_column is null;
Postgres Version: 8.3.6
Os.: Fedora Core 9
4 Gb Ram
On Thu, Apr 23, 2009 at 2:29 PM, Kevin Grittner kevin.gritt...@wicourts.gov
wrote:
Rafael Domiciano rafael.domici...@gmail.com wrote:
I have a large table to do update (in every
On Thu, Apr 23, 2009 at 4:06 PM, Kevin Grittner kevin.gritt...@wicourts.gov
wrote:
Rafael Domiciano rafael.domici...@gmail.com wrote:
Doing the alter table to add the new column was fast: ALTER TABLE
table1 ADD COLUMN new_column date;
So far, so good.
The problem is that I have to do
On Tue, Mar 31, 2009 at 1:20 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Tue, Mar 31, 2009 at 10:04 AM, Rafael Domiciano
rafael.domici...@gmail.com wrote:
Hello People,
I have some doubts about Vacuum Full. There We go:
1) The Only thing that Vacuum Full (Only Full, not Analyze
Remaining
Table011000 600 400
Or Something like that!
Thnks for responses,
Rafael Domiciano
, 2009 at 11:01 AM, Rafael Domiciano
rafael.domici...@gmail.com wrote:
I used to run vacuum full in one of my bases, but now i'm not running
anymore vacuum full, just vacuum analyze in the past 1 month, but the
number
of necessary pages is increasing every day, now it's in 311264
,
and is that what i'm looking for. But pg_cluster seems that is no more
upgraded, and there is a lot of bugs and errors.
I'm trying now the CyberCluster from CyberTech, developed under pgcluster.
I hope that you could understand the scenario.
Thnks,
Rafael Domiciano
On Mon, Feb 16, 2009 at 5:01 PM, Scott
, this number get not decreased.
I now that vacuum full reorders the relation, but it's the only thing that
it does?
Thnks,
Rafael Domiciano
On Thu, Feb 19, 2009 at 1:37 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Thu, Feb 19, 2009 at 9:35 AM, Jessica Richard rjes...@yahoo.com
wrote:
I am
= 30 and the dirty_background_ratio = 1.
I don't know what more to do to solve this slow down problem.
Somebody have any ideia?
Thnks,
Rafael Domiciano
2008/12/9 Rafael Domiciano rafael.domici...@gmail.com
Maybe Could be Check-Points? I have changed the parameters sometime ago.
Follow
, Dec 8, 2008 at 10:17 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
Here's the output. While the process was running my database get sometime
without doing anything.
You said that I probably get low numbers, but what numbers?
We're looking for MB/s and the bi/bo fields in bmstat (blocks
.
The machine is a: 2 x Intel Xeon Dual-Core 2.3 GHz, 2 Gb RAM. The load on
machine is about at 1 transactions / m
Maybe I need more RAM memory?
2008/11/26 Scott Marlowe [EMAIL PROTECTED]
On Wed, Nov 26, 2008 at 12:54 PM, Matthew T. O'Connor [EMAIL PROTECTED]
wrote:
Rafael Domiciano wrote
The Hard Drive is a SATA-II 150 Gb, dedicate to postgres service.
2008/12/8 Scott Marlowe [EMAIL PROTECTED]
On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
Hello guys,
I tried to modify my vacuum routine, and started to only run vacuum
verbose
analyze diary followed
No, I'm gonna to try
2008/12/8 Scott Marlowe [EMAIL PROTECTED]
On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
Hello guys,
I tried to modify my vacuum routine, and started to only run vacuum
verbose
analyze diary followed by a reindex weekly.
Have you tried
1 Drive Only. This server has no RAID.Do you think that the I/O is very high
and I'm needing a RAID?!
2008/12/8 Scott Marlowe [EMAIL PROTECTED]
On Mon, Dec 8, 2008 at 9:11 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
How I do to see my I/O subsystem? vmstat? If so, follow:
No, I mean, how
some information.
Thanks,
Rafael Domiciano
índices foram apagadas.
1035 páginas de índice foram removidas, 1035 são reutilizáveis.
CPU 0.27s/1.97u sec elapsed 13.14 sec.
2008/11/26 Rafael Martinez [EMAIL PROTECTED]
Rafael Domiciano wrote:
Hei
I need some help or just some hints. I am having problems with vacuum
full in one table
Rafael Domiciano [EMAIL PROTECTED]:
The database has around 40 Gb.
If I not use vacuum full everyday the database get very slow.
There is no deadlock on the database.
You didn't mention if you were using autovacuum or not. You also
didn't mention whether or not you'd tried regular vacuums
.
For autovacuum settings you need to set and see if it's ok for you.
to see if the vacuum is running you can use the command ps axf | grep
postgres on the linux server. Sometimes autovacuum is so fast that you even
notice him.
I hope that I helped
Best Regards,
Rafael Domiciano
2008/10/31 Isabella
Hi there.
I increased the wal_buffers and no change made.
I'm beggining to think that my problem is not related to checkpoint cia
as I said early.
I have decreased the checkpoint_timeout to 3 min and the slow down
continuin' ocorring after each 5 min.
In this slowdown the postgres does nothing,
names to it like: gap, stall, slowdown... I don't know the
write expression for this situation.
I hope you can help me.
Thnks,
Rafael Domiciano
Postgres DBA
2008/10/7 [EMAIL PROTECTED]
What version of postgres are you running ? and please also provide more
information about your suspected
Ok,
I'm trying this...
Thnks a lot!
2008/10/6 Scott Marlowe [EMAIL PROTECTED]
On Mon, Oct 6, 2008 at 7:56 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
I'm using 8.3.3 version in this machine..!
So, the shared_buffers set to 100Mb is ok? Or 500Mb is better?
This server we call Reporter
#bgwriter_all_percent = 0.333 # 0-100% of all buffers
scanned/round
#bgwriter_all_maxpages = 5 # 0-1000 buffers max written/round
I am trying now to increase the checkpoint_segments to 40...
2008/10/8 Brad Nicholson [EMAIL PROTECTED]
On Wed, 2008-10-08 at 10:31 -0200, Rafael
# 0-100% of all buffers
scanned/round
#bgwriter_all_maxpages = 5 # 0-1000 buffers max written/round
I am trying now to increase the checkpoint_segments to 40...
2008/10/8 Brad Nicholson [EMAIL PROTECTED]
On Wed, 2008-10-08 at 10:31 -0200, Rafael Domiciano wrote:
The server
% of all buffers
scanned/round
#bgwriter_all_maxpages = 5 # 0-1000 buffers max written/round
I am trying now to increase the checkpoint_segments to 40...
2008/10/8 Brad Nicholson [EMAIL PROTECTED]
On Wed, 2008-10-08 at 10:31 -0200, Rafael Domiciano wrote:
The server is running
written/round
I am trying now to increase the checkpoint_segments to 40...
2008/10/8 Brad Nicholson [EMAIL PROTECTED]
On Wed, 2008-10-08 at 10:31 -0200, Rafael Domiciano wrote:
The server is running Postgres 8.2.4
When the server is doing too much operations like I, U or D the
postgres stop
[EMAIL PROTECTED]
Rafael Domiciano [EMAIL PROTECTED] wrote:
What Does wal_buffers do?
http://www.postgresql.org/docs/8.2/interactive/runtime-config-wal.html#GUC-WAL-BUFFERS
-Kevin
that this slowndown is occuring for 5 min...! So I'm suposing
that the problem is in the checkpoint_timeout.
What's the impact to chang it to:
checkpoint_timeout = 2min or
checkpoint_timeout = 5min
Tnhks,
Rafael Domiciano
is about shared_buffers, in postgresql.conf I have: min 128kB or
max_connections*16kB # (change requires restart)
So I did:
300 * (16Kb / 1024) = 4,69?
What this result means?
Thnks all,
Rafael Domiciano
8.3
Dual Core
2008/10/6 Scott Marlowe [EMAIL PROTECTED]
On Mon, Oct 6, 2008 at 5:52 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
HI people,
I'm tuning a server that is a long time abandoned, and this server is a
little slow.
What version pgsql is it running? If it's 7.4 or before, you
Hello,
If you want to get the value of a autogenerated column it's better to use
RETURNING
insert into something returning primary key...
Best Regards,
Rafael Domiciano
Postgres DBA
2008/9/15 Scott Marlowe [EMAIL PROTECTED]
On Mon, Sep 15, 2008 at 11:53 AM, c k [EMAIL PROTECTED]
wrote
the vacuum daemon.
All machines I had problems are Slony-slaves.
Best Regards,
Rafael Domiciano
Postgres DBA
2008/9/30 Steve Crawford [EMAIL PROTECTED]
Carol Walter wrote:
Ah-h-h, that's exactly my question. What part of Postgres takes care of
this itself. I'm asking because I had 86 pg_clog
Did you verified if isn't the software that is doing this?
2008/8/12 subamathy [EMAIL PROTECTED]
Hi,
We are having problems resulting from users being able to create
duplicate records
in table.
Below is the description of the table
Column | Type | Modifiers
Hi there,
I have a situation that is a bit strange.
I discovered today that I can login in programs like EMS SQL Manager and in
the internal software (via ODBC) without using the password for the user.
Example:
Configuration on the ODBC:
datasource: postgres
database: Postgres
server: IP
user:
.
Postgres version: 8.3.3
Anyone knows anything?
Regards,
Rafael Domiciano
to get a time to do a condition.
I couldn't do the SQL
2008/7/28 Kenneth Marshall [EMAIL PROTECTED]
What exactly are you hoping for? I do not think that adding two
times makes sense. Maybe you want one to be an interval?
Ken
On Mon, Jul 28, 2008 at 03:16:12PM -0300, Rafael Domiciano wrote
parameter?
The default assigned now is 24 Mb.
Thanks
Rafael Domiciano
The Postgres version is 8.3.3 and I am using Fedora Core 8.
I have in the actual server around 70 connections the same time. I am
assigning for this 100.
2008/6/30 Tino Schwarze [EMAIL PROTECTED]:
On Mon, Jun 30, 2008 at 02:52:05PM -0300, Rafael Domiciano wrote:
Folks, I am configuring
, the monitoring of the server is done using the unix command:
loguptime
With the time we discovered that when loguptime is up than 1.0 the response
begin to late, and the applications begin to take Time-out.
2008/6/30 Tino Schwarze [EMAIL PROTECTED]:
On Mon, Jun 30, 2008 at 04:01:14PM -0300, Rafael Domiciano
.
2008/6/30 Alvaro Herrera [EMAIL PROTECTED]:
Rafael Domiciano escribió:
Yes, the server just does S, U, I and D.
The queries is pretty simples, don't have huge joins across tables...
In this server I have around 500 tables, the largest are:
9 millions tuples | 5 millions tuples
I have schedelus to run vacuum at the night, it starts at 01:00 AM
2008/6/30 Alvaro Herrera [EMAIL PROTECTED]:
Rafael Domiciano escribió:
No, i don't have autovacum.
We tried it sometime ago, and the applications began to take time-out.
I think we don't need autovacum, along the day
No, but is more common Insert and Update than delete.
While I have around 50.000 Insert and Update, in delete is 5.000
2008/6/30 Alvaro Herrera [EMAIL PROTECTED]:
Rafael Domiciano escribió:
I have schedelus to run vacuum at the night, it starts at 01:00 AM
Do you execute lots of updates
Hello,
There a some differences from MySQL to PostgreSQL. In PostgreSQL we use
Functions, what you called Store Procedures, that do the same thing.
In Postgres you can combine the Functions with Triggers.
Triggers are procedures that will be done when you do some U, I or D, you
have to specific
give me a light?!
Thnks
Rafael Domiciano
Senffnet Ltda.
DBA Postgres
about?
2008/6/13 Tom Lane [EMAIL PROTECTED]:
Milen A. Radev [EMAIL PROTECTED] writes:
Rafael Domiciano написа:
I need to create a role (Postgres user) that cannot drop or create
table,
but can create TEMP tables. This role must do I, U and D normally.
For a role to be able to create
52 matches
Mail list logo