On Tue, Oct 8, 2013 at 3:05 PM, 高健 wrote:
> Hello:
>
>
>
>
>
> Thank you all for kindly replying my question.
>
>
> I read the documentation about pg_basebackup.
>
>
> The description says:
>
> The server must also be configured with max_wal_senders set high enough to
> leave at least one session
Hello:
Thank you all for kindly replying my question.
I read the documentation about pg_basebackup.
The description says:
The server must also be configured with max_wal_senders set high enough to
leave at least one session available for the backup.
Dose it mean:
If I am building a one
Aftab Ahmed Chandio wrote
> I found 85 ms time unit in DOS (win7) (laptop 4cores). both Java and
> PostgreSQL installed and invoked on the same machine, respectively.
> On the other hand, I use same process (separate installation) on linux on
> 8 cores physical machine with 2times greater then lapt
On 10/7/2013 6:48 PM, Aftab Ahmed Chandio wrote:
I found 85 ms time unit in DOS (win7) (laptop 4cores). both Java and
PostgreSQL installed and invoked on the same machine, respectively.
On the other hand, I use same process (separate installation) on linux
on 8 cores physical machine with 2times
Aftab Ahmed Chandio wrote:
> My query processes from JDBC (Java Program) to PostgreSQL. I use
> system time by invoking java function, I collect one time unit
> before the query statement perform and second after the execution
> of query statement.
> I found 85 ms time unit in DOS (win7) (laptop
Hi,
I want to know the reason behind the case:
My query processes from JDBC (Java Program) to PostgreSQL. I use system time by
invoking java function, I collect one time unit before the query statement
perform and second after the execution of query statement.
I found 85 ms time unit in DOS (win
On 10/7/2013 6:46 PM, David Kerr wrote:
On Mon, Oct 07, 2013 at 06:32:57PM -0400, Guy Rouillier wrote: - So,
I ran "select pg_relation_filenode(614804)" and got no results. Any
- suggestions on how I can uncover the identify of this node? - -
Thanks much.
You could try oid2name:
http://www.post
On Mon, Oct 07, 2013 at 06:32:57PM -0400, Guy Rouillier wrote:
- On 10/7/2013 5:58 PM, Steve Atkins wrote:
- >
- >On Oct 7, 2013, at 2:48 PM, Guy Rouillier
- >wrote:
- >
- >>We have a fairly large (1 TB) database we put on all SSDs because
- >>of a very high insert and update rate (38 million rows
On 10/7/2013 5:58 PM, Steve Atkins wrote:
On Oct 7, 2013, at 2:48 PM, Guy Rouillier
wrote:
We have a fairly large (1 TB) database we put on all SSDs because
of a very high insert and update rate (38 million rows/day). As
our business has grown, we've been running into space constraints,
so w
On 10/07/2013 07:51 AM, Ovid wrote:
Hi all,
This problem has also been posted to Stack
Overflow.
http://stackoverflow.com/questions/19227920/altering-a-parent-table-in-postgresql-8-4-breaks-child-table-defaults
The problem: In Postgresql 8.4 (not tested on other versions), if table
`temp_perso
On Oct 7, 2013, at 2:48 PM, Guy Rouillier wrote:
> We have a fairly large (1 TB) database we put on all SSDs because of a very
> high insert and update rate (). As our business has grown, we've been
> running into space constraints, so we went looking for files we might be able
> to delete.
We have a fairly large (1 TB) database we put on all SSDs because of a
very high insert and update rate (). As our business has grown, we've
been running into space constraints, so we went looking for files we
might be able to delete.
We found a large number (662 out of 1465 total ) and size
On Mon, Oct 7, 2013 at 11:44 AM, Michal TOMA wrote:
> I gave it in my first post. It is a software raid 1 of average 7200 rpm
> disks
> (Hitachi HDS723020BLE640) for the main tablespace and a software raid 1 of
> SSDs for onother tablespace and alos the partition holding the pg_xlog
> directory.
Talend?
http://talend.com/
But usually all major ETL tools do work with any database including PostgreSQL
On Monday 07 October 2013 17:54:36 Vick Khera wrote:
> http://lmgtfy.com/?q=postgres+ETL+tools
>
> On Mon, Oct 7, 2013 at 11:02 AM, sunpeng wrote:
> > Hi, Friends, are there any ETL tools (fr
Talend?
http://talend.com/
But usually all major ETL tools do work with any database including PostgreSQL
On Monday 07 October 2013 17:54:36 Vick Khera wrote:
> http://lmgtfy.com/?q=postgres+ETL+tools
>
> On Mon, Oct 7, 2013 at 11:02 AM, sunpeng wrote:
> > Hi, Friends, are there any ETL tools (fr
I gave it in my first post. It is a software raid 1 of average 7200 rpm disks
(Hitachi HDS723020BLE640) for the main tablespace and a software raid 1 of
SSDs for onother tablespace and alos the partition holding the pg_xlog
directory.
The problem is not the workload as the application is a web c
Hello
you are missing some from basic packages on your system probably
postgresql-devel.i686 : PostgreSQL development header files and libraries
postgresql-server.i686 : The programs needed to create and run a PostgreSQL
Regards
Pavel Stehule
2013/10/7
> Hi,
>
> I have some problems to inst
Hi all,
This problem has also been posted to Stack Overflow.
http://stackoverflow.com/questions/19227920/altering-a-parent-table-in-postgresql-8-4-breaks-child-table-defaults
The problem: In Postgresql 8.4 (not tested on other versions), if table
`temp_person_two` inherits from`temp_person`, de
Hi,
I have some problems to install the pg_similarity Module. It's my first time to install something like that and I'm a novice in Linux.
This is the Introduction:
tar -zxf pg_similarity-0.0.19.tgz
$ cd pg_similarity-0.0.19
$ $EDITOR Makefile # edit PG_CONFIG iif necessary
$ USE_PGXS=1 make
$
On Mon, Oct 07, 2013 at 09:33:44AM +, Françoise Singer wrote:
> Dear Sirs,
>
> Could you please take my e-mail adress out of your conversations?
Hi,
I don't see this address (francoise.sin...@amma.be) subscribed to
pgsql-general@postgresql.org, but I do see singer.franco...@medicalservices.b
On Mon, Oct 7, 2013 at 6:23 AM, Marcin Mańk wrote:
> On Thu, Oct 3, 2013 at 11:56 PM, Michal TOMA wrote:
>
>>
>> This is what I can see in the log:
>> 2013-10-03 13:58:56 CEST LOG: checkpoint starting: xlog
>> 2013-10-03 13:59:56 CEST LOG: checkpoint complete: wrote 448 buffers
>> (0.2%);
http://lmgtfy.com/?q=postgres+ETL+tools
On Mon, Oct 7, 2013 at 11:02 AM, sunpeng wrote:
> Hi, Friends, are there any ETL tools (free or commercial) available for
> PostgreSQL?
> Thanks!
> peng
>
Hi, Friends, are there any ETL tools (free or commercial) available for
PostgreSQL?
Thanks!
peng
Hello,
I observe the following behavior with PostgreSQL 9.3.0 when I create a
materialized view with the no data option, which references in a subquery
another materialized view also created with the no data option:
(ls@[local]:5432) [ls] > CREATE MATERIALIZED VIEW t1 AS SELECT text 'foo'
AS col1
On 10/06/2013 09:53 PM, Amit Langote wrote:
Hi,
On Mon, Oct 7, 2013 at 12:02 PM, 高健 wrote:
Hello :
I found that for PG9.2.4, there is parameter max_wal_senders,
But there is no parameter of max_wal_receivers.
max_wal_senders is the maximum number of WAL sender processes that a
primary s
The database is about 1TB large.
Thera are mainly 4 tables 2 with row sizes about 1000 bytes and 2 with rows
with about 200 bytes but contaniong also several usually large (the size of
an average webpage) text fields.
My initial setting was 16GB of shared buffers I tried with 2GB and did not
not
On Thu, Oct 3, 2013 at 11:56 PM, Michal TOMA wrote:
>
> Now I have:
> checkpoint_completion_target = 0.9
> wal_buffers = 8MB
> checkpoint_segments = 16
> checkpoint_timeout = 20min
> shared_buffers = 2GB
> log_checkpoints = on
>
> This is what I can
> > > On Oct 7, 2013, at 11:34, Toni Helenius
> > >
> > > wrote:
> > >
> > > > Hi,
> > > >
> > > > yes, I'm cheating by using GUI :) (PgAdmin)
> > >
> > > Please do not top-post.
> > >
> > > Analyze is an entirely different command than Explain analyze.
> > Analyze
> > > updates the statistics of
> > On Oct 7, 2013, at 11:34, Toni Helenius
> >
> > wrote:
> >
> > > Hi,
> > >
> > > yes, I'm cheating by using GUI :) (PgAdmin)
> >
> > Please do not top-post.
> >
> > Analyze is an entirely different command than Explain analyze.
> Analyze
> > updates the statistics of tables, while Explain anal
> On Oct 7, 2013, at 11:34, Toni Helenius
> wrote:
>
> > Hi,
> >
> > yes, I'm cheating by using GUI :) (PgAdmin)
>
> Please do not top-post.
>
> Analyze is an entirely different command than Explain analyze. Analyze
> updates the statistics of tables, while Explain analyze tells how those
> sta
On Oct 7, 2013, at 11:34, Toni Helenius wrote:
> Hi,
>
> yes, I'm cheating by using GUI :) (PgAdmin)
Please do not top-post.
Analyze is an entirely different command than Explain analyze. Analyze updates
the statistics of tables, while Explain analyze tells how those statistics
affect the qu
Hi,
yes, I'm cheating by using GUI :) (PgAdmin)
Here:
"Aggregate (cost=18240.50..18240.51 rows=1 width=0) (actual
time=2911.117..2911.119 rows=1 loops=1)"
" -> Seq Scan on min1_009 (cost=0.00..18108.60 rows=52760 width=0) (actual
time=5.390..2816.274 rows=52760 loops=1)"
"Total runtime: 29
On Oct 7, 2013, at 11:23, Toni Helenius wrote:
> The output of analyze:
> "Aggregate (cost=18240.50..18240.51 rows=1 width=0)"
> " -> Seq Scan on min1_009 (cost=0.00..18108.60 rows=52760 width=0)"
That's the output of Explain, not of Explain Analyze. The latter has actual
measurements to go
Hello,
I have a table with 961 columns. 1 of the columns is included in a primary key.
The table has 52 760 rows. The table size is 137 MB and indexes size is 1176 kB
(just the primary key). When I try:
SELECT count(*)
on it, it uses Seq Scan instead of Index scan. The query takes ~3 seconds. I
whiplash writes:
> Hello! I have C-language stored function like this:
> CREATE FUNCTION testfunc ( x real, y real )
> RETURNS real AS
> 'testfunc'
> LANGUAGE C STRICT;
> If i use this function (SELECT testfunc ( 0.1, 0.2 )) I get result with
> type "double precision".
What's your basis for ass
35 matches
Mail list logo
