On 14 August 2013 Rushabh Lathia wrote:
postgres=# create table test ( a timestamptz);
CREATE TABLE
-- Date with year 1000
postgres=# insert into test values ( 'Sat Mar 11 23:58:48 1000 IST');
INSERT 0 1
-- Now try with year 1 it will return error
postgres=# insert into test values ( 'Sat
On Tue, 17 September 2013 14:33 Rushabh Lathia wrote:
On Mon, Sep 16, 2013 at 7:22 PM, Haribabu kommi
haribabu.ko...@huawei.commailto:haribabu.ko...@huawei.com wrote:
On 14 August 2013 Rushabh Lathia wrote:
postgres=# create table test ( a timestamptz);
CREATE TABLE
-- Date with year 1000
On 27 September 2013 15:04 Rushabh Lathia wrote:
On Tue, Sep 17, 2013 at 6:23 PM, Haribabu kommi
haribabu.ko...@huawei.commailto:haribabu.ko...@huawei.com wrote:
I feel changing the year value to accept the length (4) is not simple.
So many places the year length crossing more than length 4
On 03 October 2013 19:30 Bruce Momjian wrote:
On Thu, Oct 3, 2013 at 11:54:14AM +0530, Rushabh Lathia wrote:
Thanks Bruce.
Yes for me main problem was to make assumption that a 5-digit number
is a year, as was bit worried about side effect of that assumption in
the date/time module. I
On 08 October 2013 15:22 KONDO Mitsumasa wrote:
(2013/10/08 17:33), Haribabu kommi wrote:
The checkpoint_timeout and checkpoint_segments are increased to make sure no
checkpoint happens during the test run.
Your setting is easy occurred checkpoint in checkpoint_segments = 256. I don't
know
On 10 October 2013 23:06 Fujii Masao wrote:
On Wed, Oct 9, 2013 at 1:35 PM, Haribabu kommi haribabu.ko...@huawei.com
wrote:
Thread-1
Threads-2
Head code FPW
vacuum is not happening on a heavily modified big table even if the dead tuples
are more than configured threshold.
This is because during at the end of vacuum, the number of dead tuples of the
table is reset as zero, because
of this reason the dead tuples which are occurred during the vacuum
On 12 October 2013 11:30 Tom Lane wrote:
Haribabu kommi haribabu.ko...@huawei.com writes:
To handle the above case instead of directly resetting the dead tuples
as zero, how if the exact dead tuples are removed from the table stats. With
this approach vacuum gets triggered frequently thus
On 20 October 2013 12:06 Amit Kapila wrote:
On Tue, Oct 15, 2013 at 3:37 PM, Haribabu kommi haribabu.ko...@huawei.com
wrote:
On 12 October 2013 11:30 Tom Lane wrote:
Haribabu kommi haribabu.ko...@huawei.com writes:
To handle the above case instead of directly resetting the dead
tuples as zero
On 22 October 2013 10:15 Amit Kapila wrote:
On Mon, Oct 21, 2013 at 10:54 AM, Haribabu kommi haribabu.ko...@huawei.com
wrote:
Yes, it's correct. nkeep counter have the dead tuples which are recently
dead and are not vacuumed. The removal of tuples vacuumed from dead tuples
should
Here I have added some more regression tests to improve the missing function
coverage of
schemacmds.c, user.c and tablespace.c.
The added tests are mainly RENAME TO and OWNER TO support.
patches are attached in the mail.
please check and provide your suggestions.
Regards,
Hari babu.
There is an ident context leak which is occurs during reload of configuration
files when
there is no ident configuration items are present in the configuration file.
In function load_ident(), New context is allocated to store the
new_parsed_lines and deletes
the old context when
On 07 November 2013 09:42 Amit Kapila wrote:
On Tue, Oct 22, 2013 at 2:09 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 22 October 2013 10:15 Amit Kapila wrote:
On Mon, Oct 21, 2013 at 10:54 AM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
Actually what I had in mind
On 08 November 2013 18:35 Amit Kapila wrote:
On Fri, Nov 8, 2013 at 10:56 AM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 07 November 2013 09:42 Amit Kapila wrote:
I am not sure whether the same calculation as done for
new_rel_tuples
works for new_dead_tuples, you can once check
On 12 November 2013 08:47 Amit Kapila wrote:
On Mon, Nov 11, 2013 at 3:14 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 08 November 2013 18:35 Amit Kapila wrote:
On Fri, Nov 8, 2013 at 10:56 AM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 07 November 2013 09:42 Amit
On 01 October 2013 00:56 Amit Kapila wrote:
On Mon, Sep 30, 2013 at 9:07 PM, Peter Eisentraut pete...@gmx.net
wrote:
On 9/28/13 3:05 AM, Amit Kapila wrote:
Now as we have an agreement, I had updated patch for below left
issues:
Regression tests are failing.
Thanks for informing. I
Please find attached the patch, for adding a new option for pg_basebackup, to
specify a different directory for pg_xlog.
Design
A new option: xlogdir is added to the list of options for pg_basebackup. The
new option is not having an equivalent short option letter.
This option will allow the
On 15 November 2013 10:00 Amit Kapila wrote:
On Wed, Nov 13, 2013 at 12:02 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 12 November 2013 08:47 Amit Kapila wrote:
On Mon, Nov 11, 2013 at 3:14 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 08 November 2013 18:35 Amit
On 14 November 2013 23:59 Fujii Masao wrote:
On Thu, Nov 14, 2013 at 9:08 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
Please find attached the patch, for adding a new option for
pg_basebackup, to specify a different directory for pg_xlog.
Sounds good! Here are the review comments
On 15 November 2013 17:26 Magnus Hagander wrote:
On Fri, Nov 15, 2013 at 12:10 PM, Haribabu kommi
haribabu.ko...@huawei.commailto:haribabu.ko...@huawei.com wrote:
On 14 November 2013 23:59 Fujii Masao wrote:
On Thu, Nov 14, 2013 at 9:08 PM, Haribabu kommi
haribabu.ko
on 15 November 2013 17:26 Magnus Hagander wrote:
On Fri, Nov 15, 2013 at 12:10 PM, Haribabu kommi
haribabu.ko...@huawei.commailto:haribabu.ko...@huawei.com wrote:
On 14 November 2013 23:59 Fujii Masao wrote:
On Thu, Nov 14, 2013 at 9:08 PM, Haribabu kommi
haribabu.ko
On 16 November 2013 09:43 Amit Kapila wrote:
On Fri, Nov 15, 2013 at 10:18 PM, Peter Eisentraut pete...@gmx.net
wrote:
On 11/14/13, 2:50 AM, Amit Kapila wrote:
Find the rebased version attached with this mail.
Doesn't build:
openjade -wall -wno-unused-param -wno-empty
On 17 November 2013 00:55 Fujii Masao wrote:
On Sat, Nov 16, 2013 at 2:27 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
on 15 November 2013 17:26 Magnus Hagander wrote:
On Fri, Nov 15, 2013 at 12:10 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 14 November 2013 23:59
On 18 November 2013 11:19 Haribabu kommi wrote:
On 17 November 2013 00:55 Fujii Masao wrote:
On Sat, Nov 16, 2013 at 2:27 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
on 15 November 2013 17:26 Magnus Hagander wrote:
On Fri, Nov 15, 2013 at 12:10 PM, Haribabu kommi
On 18 October 2013 13:35 KONDO Mitsumasa wrote:
Hi,
I submit improvement of pg_stat_statement usage patch in CF3.
In pg_stat_statement, I think buffer hit ratio is very important value.
However, it is difficult to calculate it, and it need complicated SQL.
This patch makes it more simple
On 17 November 2013 12:25 Amit Kapila wrote:
On Sat, Nov 16, 2013 at 4:35 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 16 November 2013 09:43 Amit Kapila wrote:
On Fri, Nov 15, 2013 at 10:18 PM, Peter Eisentraut pete...@gmx.net
wrote:
On 11/14/13, 2:50 AM, Amit Kapila wrote
On 18 November 2013 18:45 Fujii Masao wrote:
On Mon, Nov 18, 2013 at 6:31 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 18 November 2013 11:19 Haribabu kommi wrote:
On 17 November 2013 00:55 Fujii Masao wrote:
On Sat, Nov 16, 2013 at 2:27 PM, Haribabu kommi
haribabu.ko
On 18 November 2013 20:01 Amit Kapila wrote:
On Mon, Nov 18, 2013 at 6:28 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 17 November 2013 12:25 Amit Kapila wrote:
On Sat, Nov 16, 2013 at 4:35 PM, Haribabu kommi
Find the rebased version attached with this mail
On 18 November 2013 23:25 Andres Freund wrote:
On 2013-11-18 15:01:42 +, Haribabu kommi wrote:
/*
+ * Returns the malloced string of containing current working
directory.
+ * The caller has to take care of freeing the memory.
+ * On failure exits with error code.
+ */
+static
On 19 November 2013 09:59 Amit Kapila wrote:
On Mon, Nov 18, 2013 at 8:31 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 18 November 2013 20:01 Amit Kapila wrote:
Code changes are fine.
If two or three errors are present in the configuration file, it
prints the last error
On 18 November 2013 23:30 Fujii Masao wrote:
On Tue, Nov 19, 2013 at 12:01 AM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 18 November 2013 18:45 Fujii Masao wrote:
On Mon, Nov 18, 2013 at 6:31 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 18 November 2013 11:19
On 19 November 2013 19:12 Fujii Masao wrote:
On Tue, Nov 19, 2013 at 9:14 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 18 November 2013 23:30 Fujii Masao wrote:
On Tue, Nov 19, 2013 at 12:01 AM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
Thanks for newer version
on 20 November 2013 23:44 Gavin Flower wrote:
On 20/11/13 23:43, Haribabu kommi wrote:
I tried using of stat'ing in two directories, which is having a problem in
windows.
So modified old approach to detect limited errors. Updated patch attached.
This will detect and throw an error
On 19 November 2013 10:33 Amit Kapila wrote:
If I understood correctly, then your patch's main intention is to
correct the estimate of dead tuples, so that it can lead to Vacuum
cleaning the table/index which otherwise is not happening as per
configuration value (autovacuum_vacuum_threshold)
On 24 November 2013 03:04 David Rowley wrote:
I've done a quick benchmark on this this morning.
Note that I'm using windows here and I used powershell to time the regression
run with the following command:
PS D:\Postgres\b\src\tools\msvc Measure-Command { .\vcregress.bat check }
I ran the tests
On 25 November 2013 10:43 Amit Kapila wrote:
On Fri, Nov 22, 2013 at 12:12 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 19 November 2013 10:33 Amit Kapila wrote:
If I understood correctly, then your patch's main intention is to
correct the estimate of dead tuples, so that it can
On 26 November 2013 23:11 Fujii Masao wrote:
On Wed, Nov 20, 2013 at 7:43 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
I tried using of stat'ing in two directories, which is having a
problem in windows.
So modified old approach to detect limited errors. Updated patch
attached
On 27 November 2013 10:35 Fujii Masao wrote:
On Wed, Nov 27, 2013 at 1:27 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 26 November 2013 23:11 Fujii Masao wrote:
On Wed, Nov 20, 2013 at 7:43 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
I tried using of stat'ing in two
On 29 November 2013 12:00 Amit Kapila wrote:
On Tue, Nov 26, 2013 at 7:26 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 25 November 2013 10:43 Amit Kapila wrote:
On Fri, Nov 22, 2013 at 12:12 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 19 November 2013 10:33 Amit
On 27 November 2013 10:35 Fujii Masao wrote:
On Wed, Nov 27, 2013 at 1:27 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 26 November 2013 23:11 Fujii Masao wrote:
On Wed, Nov 20, 2013 at 7:43 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
I tried using of stat'ing in two
On 05 December 2013 21:16 Amit Kapila wrote:
Note -
a. Performance is data is taken on my laptop, needs to be tested on
some better m/c b. Attached Patch is just a prototype of chunkwise
concept, code needs to be improved and decode
handling/test is pending.
I ran the performance test
On 10 December 2013 19:55 Alvaro Herrera wrote:
Haribabu kommi escribió:
To detect provided data and xlog directories are same or not, I
reused
the Existing make_absolute_path() code as follows.
1. Moved the make_absolute_path() function from miscinit.c to path.c
and Changed all
On 06 December 2013 11:57 Amit Kapila wrote:
On Fri, Nov 29, 2013 at 6:55 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
On 29 November 2013 12:00 Amit Kapila wrote:
On Tue, Nov 26, 2013 at 7:26 PM, Haribabu kommi
haribabu.ko...@huawei.com wrote:
Few questions about your latest
On 19 December 2013 05:31 Bruce Momjian wrote:
On Wed, Dec 11, 2013 at 10:22:32AM +, Haribabu kommi wrote:
The make_absolute_path() function moving to port is changed in
similar
way as Bruce Momjian approach. The psprintf is used to store the
error
string which Occurred
On 20 December 2013 02:02 Bruce Momjian wrote:
On Thu, Dec 19, 2013 at 05:14:50AM +, Haribabu kommi wrote:
On 19 December 2013 05:31 Bruce Momjian wrote:
On Wed, Dec 11, 2013 at 10:22:32AM +, Haribabu kommi wrote:
The make_absolute_path() function moving to port is changed
On Tue, Jan 28, 2014 at 1:17 PM, Peter Eisentraut wrote:
On 11/30/13, 6:59 AM, Haribabu kommi wrote:
To detect provided data and xlog directories are same or not, I reused
the
Existing make_absolute_path() code as follows.
I note that initdb does not detect whether the data and xlog
On Sat, Feb 8, 2014 at 12:10 PM, Peter Eisentraut pete...@gmx.net wrote:
On 1/29/14, 7:37 PM, Haribabu Kommi wrote:
On Tue, Jan 28, 2014 at 1:17 PM, Peter Eisentraut wrote:
On 11/30/13, 6:59 AM, Haribabu kommi wrote:
To detect provided data and xlog directories are same
On Sat, Feb 8, 2014 at 1:09 PM, Kohei KaiGai kai...@kaigai.gr.jp wrote:
Hello,
Because of time pressure in the commit-fest:Jan, I tried to simplifies the
patch
for cache-only scan into three portions; (1) add a hook on heap_page_prune
for cache invalidation on vacuuming a particular page.
On Thu, Feb 13, 2014 at 2:42 AM, Kohei KaiGai kai...@kaigai.gr.jp wrote:
2014-02-12 14:59 GMT+09:00 Haribabu Kommi kommi.harib...@gmail.com:
7. In ccache_find_tuple function this Assert(i_min + 1 cchunk-ntups);
can
go wrong when only one tuple present in the block
with the equal item
On Feb 15, 2014 9:19 AM, Alvaro Herrera alvhe...@2ndquadrant.com wrote:
Haribabu Kommi escribió:
I changed the balance cost calculations a little bit to give priority to
the user provided per table autovacuum parameters.
If any user specified per table vacuum parameters exists and those
Hi,
I want to propose a new feature called priority table or cache table.
This is same as regular table except the pages of these tables are having
high priority than normal tables. These tables are very useful, where a
faster query processing on some particular tables is expected.
The same
On Thu, Feb 20, 2014 at 11:38 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Haribabu Kommi kommi.harib...@gmail.com writes:
I want to propose a new feature called priority table or cache table.
This is same as regular table except the pages of these tables are having
high priority than normal
On Thu, Feb 20, 2014 at 2:26 PM, Amit Kapila amit.kapil...@gmail.comwrote:
On Thu, Feb 20, 2014 at 6:24 AM, Haribabu Kommi
kommi.harib...@gmail.com wrote:
On Thu, Feb 20, 2014 at 11:38 AM, Tom Lane t...@sss.pgh.pa.us wrote:
I want to propose a new feature called priority table or cache
On Fri, Feb 21, 2014 at 2:19 AM, Kohei KaiGai kai...@kaigai.gr.jp wrote:
Hello,
The attached patch is a revised one for cache-only scan module
on top of custom-scan interface. Please check it.
Thanks for the revised patch. Please find some minor comments.
1. memcpy(dest, tuple,
On Tue, Feb 25, 2014 at 10:44 AM, Kouhei Kaigai kai...@ak.jp.nec.comwrote:
Thanks for your testing,
Getting some compilation warnings while compiling the extension and also
I am not able to load the extension because of undefined symbol
get_restriction_qual_cost.
It seems to me you
Hi,
It's regarding a Todo item of Bit data type header reduction in some
cases. The header contains two parts. 1) The varlena header is
automatically converted to 1 byte header from 4 bytes in case of small
data. 2) The bit length header called bit_len to store the actual bit
length which is of
On Tue, Feb 25, 2014 at 11:13 AM, Haribabu Kommi
kommi.harib...@gmail.comwrote:
Thanks for the information, I will apply other patches also and start
testing.
When try to run the pgbench test, by default the cache-scan plan is not
chosen because of more cost. So I increased
On Wed, Mar 5, 2014 at 4:09 AM, Sawada Masahiko sawada.m...@gmail.comwrote:
Hi all,
I had doubts regarding behavior of CheckRequiredParameterValues() function.
I could not start standby server which is created by pg_basebackup
with following scenario.
1. Start the master server with
On Tue, Mar 4, 2014 at 3:07 PM, Kouhei Kaigai kai...@ak.jp.nec.com wrote:
4. + cchunk = ccache_vacuum_tuple(ccache, ccache-root_chunk, ctid);
+ if (pchunk != NULL pchunk != cchunk)
+ ccache_merge_chunk(ccache, pchunk);
+ pchunk = cchunk;
The merge_chunk is called
On Mon, Mar 10, 2014 at 4:24 PM, Amit Kapila amit.kapil...@gmail.com wrote:
On Mon, Mar 10, 2014 at 5:58 AM, Wang, Jing ji...@fast.au.fujitsu.com wrote:
Enclosed is the patch to implement the requirement that issue log message to
suggest VACUUM FULL if a table is nearly empty.
The
On Thu, Mar 6, 2014 at 10:15 PM, Kohei KaiGai kai...@kaigai.gr.jp wrote:
2014-03-06 18:17 GMT+09:00 Haribabu Kommi kommi.harib...@gmail.com:
I will update you later regarding the performance test results.
I ran the performance test on the cache scan patch and below are the readings
On Wed, Mar 12, 2014 at 5:26 PM, Kouhei Kaigai kai...@ak.jp.nec.com wrote:
Thanks for your efforts!
Head patched
Diff
Select - 500K772ms2659ms-200%
Insert - 400K 3429ms 1948ms 43%
On Tue, Mar 11, 2014 at 2:59 PM, Amit Kapila amit.kapil...@gmail.com wrote:
On Mon, Mar 10, 2014 at 1:13 PM, Haribabu Kommi
kommi.harib...@gmail.com wrote:
On Mon, Mar 10, 2014 at 4:24 PM, Amit Kapila amit.kapil...@gmail.com wrote:
On Mon, Mar 10, 2014 at 5:58 AM, Wang, Jing ji
On Mon, Mar 17, 2014 at 11:45 AM, Kouhei Kaigai kai...@ak.jp.nec.com wrote:
Hello,
The attached patches are revised ones according to the latest custom-plan
interface patch (v11).
The cache-scan module was re-implemented on the newer interface, and also
I noticed the extension does not
On Fri, Apr 11, 2014 at 7:44 AM, Bruce Momjian br...@momjian.us wrote:
Can someone with Windows expertise comment on whether this should be
applied?
I tested the same in windows and it is working as specified.
The same background running server can be closed with ctrl+break command.
On Fri, Apr 11, 2014 at 12:12 PM, Bruce Momjian br...@momjian.us wrote:
On Fri, Apr 11, 2014 at 11:58:58AM +1000, Haribabu Kommi wrote:
On Fri, Apr 11, 2014 at 7:44 AM, Bruce Momjian br...@momjian.us wrote:
Can someone with Windows expertise comment on whether this should be
applied?
I
On Mon, May 5, 2014 at 1:09 AM, Amit Kapila amit.kapil...@gmail.com wrote:
On Mon, Feb 17, 2014 at 7:38 AM, Haribabu Kommi
kommi.harib...@gmail.com wrote:
I modified the autovac_balance_cost function to balance the costs using
the number of running workers, instead
of default vacuum cost
On Tue, May 13, 2014 at 3:33 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Sun, May 11, 2014 at 7:30 PM, Simon Riggs si...@2ndquadrant.com wrote:
On 30 August 2013 04:55, Fujii Masao masao.fu...@gmail.com wrote:
My idea is very simple, just compress FPW because FPW is
a big part of WAL. I
On Thu, May 29, 2014 at 3:28 AM, Keith Fiske ke...@omniti.com wrote:
On Sun, Mar 23, 2014 at 10:42 PM, Haribabu Kommi kommi.harib...@gmail.com
wrote:
On Fri, Mar 21, 2014 at 5:17 PM, dar...@dons.net.au wrote:
The following bug has been logged on the website:
reclog= select * from foo
On Wed, Jun 4, 2014 at 5:46 AM, Keith Fiske ke...@omniti.com wrote:
Andres's changes on June 3rd to
https://github.com/postgres/postgres/commits/master/src/test/regress/expected/create_function_3.out
are causing patch v2 to fail for that regression test file.
postgres $ patch -p1 -i
On Thu, Jun 5, 2014 at 9:12 AM, Andres Freund and...@2ndquadrant.com wrote:
Hi,
On 2014-06-04 10:37:48 +1000, Haribabu Kommi wrote:
Thanks for the test. Patch is re-based to the latest head.
Did you look at the source of the conflict? Did you intentionally mark
the functions as leakproof
On Tue, Jun 17, 2014 at 12:30 AM, Abhijit Menon-Sen a...@2ndquadrant.com
wrote:
(Cc: to pgsql-bugs dropped.)
At 2014-03-17 18:24:55 +1100, kommi.harib...@gmail.com wrote:
*** a/doc/src/sgml/xfunc.sgml
--- b/doc/src/sgml/xfunc.sgml
***
*** 153,159 SELECT clean_emp();
---
On Thu, May 8, 2014 at 10:00 AM, Jaime Casanova ja...@2ndquadrant.com wrote:
Hi,
This patch implements $subject only when ANALYZE and VERBOSE are on.
I made it that way because for years nobody seemed interested in this
info (at least no one did it) so i decided that maybe is to much
On Mon, Jul 7, 2014 at 6:59 PM, Asif Naeem anaeem...@gmail.com wrote:
Hi Haribabu,
Thank you for sharing the patch. I have spent some time to review the
changes. Overall patch looks good to me, make check and manual testing seems
run fine with it. There seems no related doc/sgml changes ?.
On Thu, Jul 24, 2014 at 5:59 PM, Asif Naeem anaeem...@gmail.com wrote:
Sorry for being late. Thank you for sharing updated patch, sgml changes
seems not working i.e.
postgres=# select max('192.168.1.5', '192.168.1.4');
ERROR: function max(unknown, unknown) does not exist
LINE 1: select
On Mon, Aug 4, 2014 at 3:22 PM, Asif Naeem anaeem...@gmail.com wrote:
Sorry for not being clear, above mentioned test is related to following doc
(sgml) changes that seems not working as described i.e.
Table 9-35. cidr and inet Functions
FunctionReturn TypeDescriptionExampleResult
Hi Hackers,
Implementation of Parallel Sequence Scan
Approach:
1.Parallel Sequence Scan can achieved by using the background
workers doing the job of actual sequence scan including the
qualification check also.
2. Planner generates the parallel scan plan by checking the possible
criteria of
Corrected subject.
Hi Hackers,
Implementation of Parallel Sequence Scan
Approach:
1.Parallel Sequence Scan can achieved by using the background
workers doing the job of actual sequence scan including the
qualification check also.
2. Planner generates the parallel scan plan by checking the
On Sun, Aug 24, 2014 at 1:11 AM, Craig Ringer cr...@2ndquadrant.com wrote:
On 08/21/2014 02:47 PM, Haribabu Kommi wrote:
Implementation of Parallel Sequence Scan
I think you mean Parallel Sequential Scan.
Sorry for not being clear, Yes it is parallel sequential scan.
1.Parallel Sequence
On Mon, Aug 18, 2014 at 8:12 PM, Asif Naeem anaeem...@gmail.com wrote:
Thank you for sharing updated patch. With latest 9.5 source code, patch
build is failing with following error message i.e.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C catalog
schemapg.h
cd
On Sun, Aug 24, 2014 at 12:34 PM, Craig Ringer cr...@2ndquadrant.com wrote:
On 08/24/2014 09:40 AM, Haribabu Kommi wrote:
Any suggestions?
Another point I didn't raise first time around, but that's IMO quite
significant, is that you haven't addressed why this approach to fully
parallel
On Wed, Aug 27, 2014 at 8:27 AM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
Alvaro Herrera wrote:
So my proposal is a bit more complicated. First we introduce the notion
of a single number, to enable sorting and computations: the delay
equivalent, which is the cost_limit divided by
On Fri, Aug 29, 2014 at 12:39 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Haribabu Kommi kommi.harib...@gmail.com writes:
Thanks for your review. Please find the rebased patch to latest HEAD.
Committed with minor (mostly cosmetic) alterations.
Thanks.
Regards,
Hari Babu
Fujitsu Australia
Hi Hackers,
I am thinking of a possible problem with shm_mq structure spin lock.
This is used for protecting the shm_mq structure.
During the processing of any code under the spin lock, if the process
receives SIGQUIT signal then it is leading to a dead lock situation.
On Sun, Oct 26, 2014 at 10:17 AM, Andres Freund and...@2ndquadrant.com wrote:
Hi,
On 2014-10-26 08:52:42 +1100, Haribabu Kommi wrote:
I am thinking of a possible problem with shm_mq structure spin lock.
This is used for protecting the shm_mq structure.
During the processing of any code
On Sun, Oct 26, 2014 at 12:12 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Haribabu Kommi kommi.harib...@gmail.com writes:
Thanks for the details. I am sorry It is not proc_exit. It is the exit
callback functions that can cause problem.
The following is the callstack where the problem can happen
On Tue, Sep 23, 2014 at 10:38 PM, Rajeev rastogi
rajeev.rast...@huawei.com wrote:
On 22 September 2014 19:17, Heikki Linnakangas wrote:
On 09/22/2014 04:45 PM, Tom Lane wrote:
Heikki Linnakangas hlinnakan...@vmware.com writes:
On 09/22/2014 07:47 AM, Rajeev rastogi wrote:
So my proposal
On Mon, Oct 27, 2014 at 10:38 PM, Rajeev rastogi
rajeev.rast...@huawei.com wrote:
On 26 October 2014 10:42, Haribabu Kommi wrote:
I have a question regarding setting of key flags matched. Only the
first key was set as matched even if we have multiple index conditions.
Is there any reason
On Tue, Nov 11, 2014 at 10:21 AM, Andres Freund and...@2ndquadrant.com wrote:
On 2014-11-10 10:57:16 -0500, Robert Haas wrote:
Does parallelism help at all?
I'm pretty damn sure. We can't even make a mildly powerfull storage
fully busy right now. Heck, I can't make my workstation's storage
On Tue, Nov 11, 2014 at 2:35 PM, Amit Kapila amit.kapil...@gmail.com wrote:
On Tue, Nov 11, 2014 at 5:30 AM, Haribabu Kommi kommi.harib...@gmail.com
wrote:
On Tue, Nov 11, 2014 at 10:21 AM, Andres Freund and...@2ndquadrant.com
wrote:
On 2014-11-10 10:57:16 -0500, Robert Haas wrote:
Does
On Mon, Jun 30, 2014 at 5:06 PM, Abhijit Menon-Sen a...@2ndquadrant.com wrote:
I think having two columns would work. The columns could be called
database and database_list and user and user_list respectively.
The database column may contain one of all, sameuser, samegroup,
replication, but
On Wed, Jan 28, 2015 at 9:47 AM, Jim Nasby jim.na...@bluetreble.com wrote:
On 1/27/15 1:04 AM, Haribabu Kommi wrote:
Here I attached the latest version of the patch.
I will add this patch to the next commitfest.
Apologies if this was covered, but why isn't the IP address an inet instead
On Fri, Feb 20, 2015 at 5:09 PM, Alfred Perlstein bri...@mu.org wrote:
Hello,
We have a combination of 9.3 and 9.4 databases used for logging of data.
We do not need a strong durability guarantee, meaning it is ok if on crash a
minute or two of data is lost from our logs. (This is just
On Tue, Mar 10, 2015 at 3:09 PM, Amit Kapila amit.kapil...@gmail.com wrote:
On Tue, Mar 10, 2015 at 6:50 AM, Haribabu Kommi kommi.harib...@gmail.com
wrote:
On Tue, Mar 10, 2015 at 1:38 AM, Amit Kapila amit.kapil...@gmail.com
wrote:
Assuming previous patch is in right direction, I have
On Tue, Mar 10, 2015 at 1:38 AM, Amit Kapila amit.kapil...@gmail.com wrote:
Assuming previous patch is in right direction, I have enabled
join support for the patch and done some minor cleanup of
patch which leads to attached new version.
Is this patch handles the cases where the re-scan
On Wed, Mar 11, 2015 at 6:31 AM, Robert Haas robertmh...@gmail.com wrote:
On Tue, Mar 3, 2015 at 7:47 PM, Amit Kapila amit.kapil...@gmail.com wrote:
I have modified the patch to introduce a Funnel node (and left child
as PartialSeqScan node). Apart from that, some other noticeable
changes
On Mon, Mar 30, 2015 at 4:34 AM, Pavel Stehule pavel.steh...@gmail.com wrote:
Hi
I checked this patch. I like the functionality and behave.
Thanks for the review.
Here I attached updated patch with the following changes.
1. Addition of two new keyword columns
keyword_databases - The
On Fri, Mar 13, 2015 at 1:33 PM, Peter Eisentraut pete...@gmx.net wrote:
On 3/4/15 1:34 AM, Haribabu Kommi wrote:
On Wed, Mar 4, 2015 at 12:35 PM, Haribabu Kommi
kommi.harib...@gmail.com wrote:
+ foreach(line, parsed_hba_lines)
In the above for loop it is better to add check_for_interrupts
On Sat, Feb 7, 2015 at 8:26 PM, Pavel Stehule pavel.steh...@gmail.com wrote:
Hi
I am sending a review of this patch.
Thanks for the review. sorry for the delay.
4. Regress tests
test rules... FAILED -- missing info about new view
Thanks. Corrected.
My objections:
On Wed, Mar 4, 2015 at 12:35 PM, Haribabu Kommi
kommi.harib...@gmail.com wrote:
+ foreach(line, parsed_hba_lines)
In the above for loop it is better to add check_for_interrupts to
avoid it looping
if the parsed_hba_lines are more.
Updated patch is attached with the addition
1 - 100 of 544 matches
Mail list logo