-
PostgreSQL 9.1.9 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit
regards,
- --
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway
PGP Public Key: http://fol
otiation_limit to 0 in your postgresql.conf and
restart postgreSQL.
regards,
--
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/22/2013 12:40 PM, Stuart Bishop wrote:
> On Fri, Feb 22, 2013 at 4:41 PM, Rafael Martinez
> wrote:
>> According to FHS-2.3, /usr/lib includes object files, libraries,
>> and internal binaries that are not intended to be ex
apt.postgresql.org service also going to use this
directory for postgres binaries?
Thanks in advance.
regards,
- --
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.14 (GNU
blem' when creating a GIN index on a
tsvector column on a 4217 MB table (This takes longer than
checkpoint_timeout)
- --
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
-BEGIN PGP SIGNATURE-
Versio
ting a GIN index on a 4217 MB table. See my first post for the
relevant information from the log file (No relevant information/errors
before this)
STATEMENT: CREATE INDEX attachments_textsearch ON attachments USING gin
(textsearchable);
Where 'textsearchable' is a tsvector column. In the sour
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/25/2011 02:08 PM, Andrew Sullivan wrote:
> On Wed, May 25, 2011 at 01:30:35PM +0200, Rafael Martinez wrote:
Thanks for your answer.
>>
>> According to the documentation [1] we can expect a maximum of
>> (3 * checkpoint
xtsearchable);
Maybe the problem is related to this?
Any ideas?, thanks in advance.
[1] http://www.postgresql.org/docs/8.3/interactive/wal-configuration.html
regards,
- --
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway
PGP Public Key: http://f
On Wed, 2011-04-13 at 06:28 -0700, Adrian Klaver wrote:
> On Wednesday, April 13, 2011 6:09:25 am Rafael Martinez wrote:
>
> Might want to take a look at:
>
[..]
> sequence). If, due to a short-term peak of log output rate, there are
> more than 3 * checkpoint_segments
his system:
PostgreSQL 9.0.3 - ext4 - RHEL5.6 - 2.6.18-238.5.1.el5 - x86_64
checkpoint_segments: 128
wal_buffers: 512kB
wal_level: archive
wal_sync_method: fdatasync
shared_buffers: 10GB
regards,
be things have improved since last time we testet.
regards,
--
Rafael Martinez,
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Marko Kreen wrote:
> On 7/16/09, Rafael Martinez wrote:
>> >> Any other ideas?
>> >
>> > The version you compile against is not the version you have running.
>> >
>>
>> Well, the only ver
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Marko Kreen wrote:
> On 7/16/09, Rafael Martinez wrote:
>> Peter Eisentraut wrote:
>> >
>> > You need to recompile your module.
>>
>> We recompile the module automatically when a new postgres cluster
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter Eisentraut wrote:
> On Thursday 16 July 2009 12:14:48 Rafael Martinez wrote:
>> ERROR: incompatible library "/usr/local/lib/pg_uname_8.4.so": magic
>> block mismatch
>> DETAIL: Server has FLOAT8PASSBYVAL = tr
statistics autovacuum uses
to find out what to do and when this should be done? Can the use of
pg_stat_reset() affect performance in any way?
regards,
- --
Rafael Martinez,
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
_VARSIZE(result, strlen(uname_pointer.machine) + VARHDRSZ);
memcpy(VARDATA(result),uname_pointer.machine,strlen(uname_pointer.machine));
}
else{
memcpy(VARDATA(result),null,sizeof(null));
}
pfree(option);
PG_RETURN_TEXT_P(result);
}
- --
Brad Nicholson wrote:
> On Wed, 2009-07-15 at 14:13 +0200, Rafael Martinez wrote:
>> Hello
>>
>> Should not the execution of pg_stat_reset() reset *all* statistics
>> counters everywhere in the database?
>
> It only resets the stats for the current datab
Rafael Martinez wrote:
> But when we execute pg_stat_reset() in our databases, not all values
> reported by pg_stat_database get updated. tup_returned, tup_fetched,
> tup_inserted, tup_updated and tup_deleted still have the old values
> after running pg_stat_reset().
>
> Am
tname | rtprod
numbackends | 40
xact_commit | 1
xact_rollback | 2
blks_read | 60
blks_hit | 264238
tup_returned | 1742832161264
tup_fetched | 67407042466
tup_inserted | 54681617
tup_updated | 11495340
tup_deleted | 18167979
Any ideas?
regards,
--
Rafael Martinez,
Ce
Rafael Martinez wrote:
> Whit Armstrong wrote:
>> anyone know a way to get nagios to monitor the number of postgres
>> connections?
>>
>> Thanks,
>> Whit
>>
>
> Hello
>
> We use this plugin. Save it under /etc/munin/plugins/pg_connections and
vity"
-----
PS.- You have to update the PATHS with the values in your system, and
the user postgres needs access to your database, for this plugin to work.
regards,
--
Rafael Martinez,
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ent unix_socket_directory values for
each cluster running on the same server.
We connect mostly via tcp/ip and not via sockets, this way the clients
do not have to remember the port running their databases.
Of course the initdb and start steps are the same as Filip has commented.
regards,
--
Y
columna_con_valores ORDER BY cnt.
[1]: http://www.postgresql.org/docs/8.3/interactive/functions-aggregate.html
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
--
Sent via pgsql-general mailing li
ctive_cache_size = 1024MB
>
50% of your RAM. 4GB in the test machine (if it is a dedicated postgres
server). It will probably help read-rate.
In addition, I will try to change these parameters also:
wal_buffers = 64
random_page_cost = 2.0
In general, faster and more disks in a RAID 1+0 / 0+
Pavel Stehule wrote:
2008/7/1 Rafael Martinez <[EMAIL PROTECTED]>:
Pavel Stehule wrote:
hello
try
memcpy(VARDATA(result),uname_pointer.release,strlen(uname_pointer.release));
SET_VARSIZE(result, strlen(uname_pointer.release) + VARHDRSZ);
[.]
This a 8.2.x system. SET_VARSIZE
Pavel Stehule wrote:
hello
try
memcpy(VARDATA(result),uname_pointer.release,strlen(uname_pointer.release));
SET_VARSIZE(result, strlen(uname_pointer.release) + VARHDRSZ);
[.]
This a 8.2.x system. SET_VARSIZE is not available.
Thanks for your time.
regards
--
Rafael Martinez
ver)
CFLAGS = $(SERVER_INCLUDES)
CC = gcc
pg_uname: pg_uname.c
$(CC) $(CFLAGS) -fpic -c $<
$(CC) $(CFLAGS) -shared -o $(basename $<).so $(basename $<).o
---
regards
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Osl
Hello
I am wondering if 8.4 is going to implement this:
ALTER DATABASE name SET TABLESPACE new_tablespace
I cannot find information in the todo list about the priority or
release that would implement this feature.
regards
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Infor
advance.
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/>
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, pleas
in to load correctly UTF8 files?
>
Hello
We have 'client_encoding = iso8859-1' in our postgresql.conf to see
properly our 'special' characters when the database is utf8. I suppose
you will have to choose the correct encoding for your language too
insteed of utf8.
--
Rafae
pen, anyone has seen this problem before?
Ideas?, tips? to find why this happened.
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
---(end of broadcast)---
On Mon, 2006-05-22 at 11:00, Peter Eisentraut wrote:
> Am Montag, 22. Mai 2006 09:17 schrieb Rafael Martinez, Guerrero:
> > To have a database on a NFS filesystem is a disaster waiting to happen,
> > specially if the NFS server is running on Linux. Not to talk on the
> > p
7;noac' I was thinking about two processes trying to access the same
file at the same time, better not to have some cache in our way that
alter the real state of the file to other processes.
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
Univers
use hard and
turn off all cache . In the server side we are talking about 'sync'
and 'no_wdelay' parameters and in the client about
'bg','hard','intr','noac' and 'tcp', probably the throughput will
improve by increasing
On Tue, 2006-05-16 at 13:01 -0400, Tom Lane wrote:
> Rafael Martinez <[EMAIL PROTECTED]> writes:
> > On Tue, 2006-05-16 at 11:14 -0400, Tom Lane wrote:
> >> So much for that theory. If you copy the table (create table foo as
> >> select * from tickets) and build
On Tue, 2006-05-16 at 12:32 -0400, Tom Lane wrote:
> Rafael Martinez <[EMAIL PROTECTED]> writes:
> > On Tue, 2006-05-16 at 11:14 -0400, Tom Lane wrote:
> >> I suspect this may be a question of a corrupt index, in which case
> >> REINDEXing the index being used woul
On Tue, 2006-05-16 at 11:14 -0400, Tom Lane wrote:
> "Rafael Martinez, Guerrero" <[EMAIL PROTECTED]> writes:
> > I have found out the sql statement with 'problems'. Can anybody explain
> > me why A) returns 12 rows and B) returns 13 rows?. The only differen
kets main
(cost=0.00..1658.82 rows=1 width=33) (actual time=0.790..3.909 rows=13
loops=1)
Index Cond: (((status)::text = 'new'::text) OR
((status)::text = 'open'::text))
Filter: ((effectiveid = id) AND ((status)::text <>
'
his, do we have any plans, is it better with 8.0
or 8.1?
Thanks in advance for your answers :)
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
signature.asc
Description: This is a digitally signed message part
in advance.
[1] http://candle.pha.pa.us/ - PostgreSQL: Past, Present, and Future
(Bruce Momjian)
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
signature.asc
Descri
On Fri, 2005-03-18 at 15:58, Tom Lane wrote:
> Rafael Martinez <[EMAIL PROTECTED]> writes:
> > On Thu, 2005-03-17 at 10:17 -0500, Tom Lane wrote:
> >> Is that a plain text, tar, or custom dump (-Ft or -Fc)? Is the behavior
> >> different if you just write
On Fri, 2005-03-18 at 09:58 -0500, Tom Lane wrote:
> Rafael Martinez <[EMAIL PROTECTED]> writes:
> > On Thu, 2005-03-17 at 10:17 -0500, Tom Lane wrote:
> >> Is that a plain text, tar, or custom dump (-Ft or -Fc)? Is the behavior
> >> different if you just write
problem with the filesystem we are using.
> Would it be
> possible to even implement that at you site at this stage ?
>
We can not do this if we want support from our "operative system
departament", they do not support XFS at the present.
--
Rafael Martinez, <[EMAIL PROTE
On Thu, 2005-03-17 at 10:17 -0500, Tom Lane wrote:
> Rafael Martinez Guerrero <[EMAIL PROTECTED]> writes:
> > We are trying to dump a 30GB+ database using pg_dump with the --file
> > option. In the beginning everything works fine, pg_dump runs and we get
> > a dumpfile.
On Thu, 2005-03-17 at 15:09, Lonni J Friedman wrote:
> On Thu, 17 Mar 2005 14:05:35 +0100, Rafael Martinez Guerrero
> <[EMAIL PROTECTED]> wrote:
> > Hello
> >
> > We are having problems with pg_dump.
> >
> > We are trying to dump a 30GB+ database using
Inodes per group: 16384
Inode blocks per group: 512
---
Regards.
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
signature.asc
?
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
signature.asc
Description: This is a digitally signed message part
body knows when this functionality will be available with
prod-quality?
--
With regards
Rafael Martinez
USIT, University of Oslo
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
48 matches
Mail list logo
