On 10.11.2013 01:47, Robert Haas wrote:
I think we've tried pretty hard to avoid algorithms where the maximum
number of lwlocks that must be held at one time is not a constant, and
I think we're in for a bad time of it if we start to deviate from that
principal. I'm not sure what to do about
On Fri, November 8, 2013 21:11, Alvaro Herrera wrote:
Here's a version 7 of the patch, which fixes these bugs and adds
opclasses for a bunch more types (timestamp, timestamptz, date, time,
timetz), courtesy of Martín Marqués. It's also been rebased to apply
cleanly on top of today's master
Hi,
According to http://www.postgresql.org/docs/9.3/static/sql-select.html#SQL-TABLE
The command
TABLE name
is completely equivalent to
SELECT * FROM name
It can be used as a top-level command or as a space-saving syntax
variant in parts of complex queries.
However, this isn't true:
2013-10-11 00:16 keltezéssel, Alvaro Herrera írta:
Boszormenyi Zoltan escribió:
2013-09-10 03:04 keltezéssel, Peter Eisentraut írta:
You need to update the dblink regression tests.
Done.
Dude, this is an humongous patch. I was shocked by it initially, but on
further reading, I observed that
Thank you,
In any case, it seems like a bad idea to me to conflate
distinct-ness with ordering, so I don't like what you did to
PathKeys.
Hmm, that sounds quite resonable in general. But the conflation
is already found in grouping_planner to some extent. The name
distinct_pathkey itself
Hello,
Your patch fails the isolation test because of changed query plans:
http://pgci.eisentraut.org/jenkins/job/postgresql_commitfest_world/175/artifact/src/test/isolation/regression.diffs/*view*/
Thank you for pointing out. I wasn't aware of that..
# Because it is not launched from the
On Mon, November 11, 2013 09:53, Erik Rijkers wrote:
On Fri, November 8, 2013 21:11, Alvaro Herrera wrote:
Here's a version 7 of the patch, which fixes these bugs and adds
opclasses for a bunch more types (timestamp, timestamptz, date, time,
timetz), courtesy of Martín Marqués. It's also
Hi,
I can't get Postgresql to execute a query with EXCEPT (or INTERSECT)
as an anti-join (or join).
Is this even possible?
If not currently possible, is this something we would like to have?
Cheers,
Colin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
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
Hi Craig,
I'd like to vote the last options. It is a separate problem (or, might
be specification), I think.
According to the document of view,
http://www.postgresql.org/docs/devel/static/sql-createview.html
| Access to tables referenced in the view is determined by permissions of
| the view
Hi,
I tried to write up a wikipage to introduce how custom-scan works.
https://wiki.postgresql.org/wiki/CustomScanAPI
Any comments please.
2013/11/6 Kohei KaiGai kai...@kaigai.gr.jp:
The attached patches provide a feature to implement custom scan node
that allows extension to replace a part
Hi All,
I want to implement and test my indexing approach.
I would like to know which are the main files to look for b tree indexing
scheme modification.
It would be great, if can share some helpful links which are needed to
understand how to modify and test an indexing scheme in postgresql.
On 11.11.2013 13:19, Rohit Goyal wrote:
Hi All,
I want to implement and test my indexing approach.
I would like to know which are the main files to look for b tree indexing
scheme modification.
It would be great, if can share some helpful links which are needed to
understand how to modify and
Hi,
Thanks for reply.
I actually want to make some changes in all operations on index like
insert, update, delete.
for example, i want store a new customized value for every key inserted in
b tree instead of storing Tuple Id as value.
Can you also pls explain me more about appoach to follow to
Colin 't Hart colinth...@gmail.com writes:
I can't get Postgresql to execute a query with EXCEPT (or INTERSECT)
as an anti-join (or join).
Is this even possible?
No, and it probably won't ever be, since the semantics aren't the same.
EXCEPT/INTERSECT imply duplicate elimination.
On Wed, Feb 20, 2013 at 5:02 PM, Heikki Linnakangas
hlinnakan...@vmware.com wrote:
On 20.02.2013 17:53, Selena Deckelmann wrote:
On Wed, Feb 20, 2013 at 6:23 AM, Magnus
Hagandermag...@hagander.netwrote:
Selena, was this reasonably reproducible for you? Would it be possible to
get a network
On 11 November 2013 14:34, Tom Lane t...@sss.pgh.pa.us wrote:
Colin 't Hart colinth...@gmail.com writes:
I can't get Postgresql to execute a query with EXCEPT (or INTERSECT)
as an anti-join (or join).
Is this even possible?
No, and it probably won't ever be, since the semantics aren't the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello
After some discussions in #pgconfeu, this is an attempt to relaunch
the discussion about how pg_dump and pg_dumpall work and the
challenges they give us in real life.
We have got bitten sometimes because of their behavior and we can see
it is
Colin 't Hart co...@sharpheart.org writes:
I would've thought it was implemented as a shortcut for SELECT *
FROM at the parse level (ie encounter TABLE and insert SELECT *
FROM into the parse tree and continue), but it seems there is more to
it.
If you look at the PG grammar you'll see that
Hi,
In the sorting code, I need to determine the datatype of my sort keys
and call some code conditionally based on the datatype. Is there any way to
determine the datatype of a column from the *backend* PostGreSQL code. is
the datatype of the column available in the query plan? Any help on
Colin 't Hart co...@sharpheart.org writes:
On 11 November 2013 14:34, Tom Lane t...@sss.pgh.pa.us wrote:
No, and it probably won't ever be, since the semantics aren't the same.
EXCEPT/INTERSECT imply duplicate elimination.
Can't we just use DISTINCT for that?
If you have to do a DISTINCT
* Rafael Martinez (r.m.guerr...@usit.uio.no) wrote:
* We need a pg_dump solution that can generate in one step all the
necessary pieces of information needed when restoring or cloning a
database. (schema, data, privileges, users and alter database/role data)
This sounds pretty reasonable and
Ishaya Bhatt ishayabh...@gmail.com writes:
In the sorting code, I need to determine the datatype of my sort keys
and call some code conditionally based on the datatype. Is there any way to
determine the datatype of a column from the *backend* PostGreSQL code. is
the datatype of the column
On 11/11/2013 08:59 AM, Rafael Martinez wrote:
* It would be great to be able to tell pg_restore that user1 in the
dump will became user2 in the restored/cloned database. The same for
the name of the database.
A general ability to rename things would be good. In particular,
restoring schema
On 11 November 2013 15:16, Tom Lane t...@sss.pgh.pa.us wrote:
Colin 't Hart co...@sharpheart.org writes:
On 11 November 2013 14:34, Tom Lane t...@sss.pgh.pa.us wrote:
No, and it probably won't ever be, since the semantics aren't the same.
EXCEPT/INTERSECT imply duplicate elimination.
Can't
On 11 November 2013 15:03, Tom Lane t...@sss.pgh.pa.us wrote:
Colin 't Hart co...@sharpheart.org writes:
I would've thought it was implemented as a shortcut for SELECT *
FROM at the parse level (ie encounter TABLE and insert SELECT *
FROM into the parse tree and continue), but it seems there
Yes!! Thats exactly what I was looking for !! Thanks :)
On Mon, Nov 11, 2013 at 7:58 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Ishaya Bhatt ishayabh...@gmail.com writes:
In the sorting code, I need to determine the datatype of my sort
keys
and call some code conditionally based on the
On Mon, Nov 11, 2013 at 4:00 AM, Tom Lane t...@sss.pgh.pa.us wrote:
In any case, the issue looks bigger than just addRangeTableEntry
itself. Do you want to write up a patch?
I was going to include it in the overflow patch but I'm now thinking I
should make it a separate commit to make sure
Colin 't Hart wrote
Methinks we should fix the documentation, something like:
The command
TABLE name
is equivalent to
SELECT * FROM name
It can be used as a top-level command or as a space-saving syntax
variant in parts of complex queries. Only the WITH, ORDER BY, LIMIT,
and
Hi,
I'd like to add support for the length modifier %z. Linux' manpages
describes it as:
z A following integer conversion corresponds to a size_t or ssize_t
argument.
Since gcc's printf format checks understand it, we can add support for
it similar to the way we added %m support.
Colin 't Hart colinth...@gmail.com writes:
Would these be difficult to build in?
Well, you'd have to worry about the ALL cases, as well as how to determine
whether you're actually getting a win (which would probably be rather
tough, really, as the choice would have to be made before we've fired
Andres Freund and...@2ndquadrant.com writes:
I'd like to add support for the length modifier %z. Linux' manpages
describes it as:
z A following integer conversion corresponds to a size_t or ssize_t
argument.
Since gcc's printf format checks understand it, we can add support for
it
On 2013-11-11 11:18:22 -0500, Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
I'd like to add support for the length modifier %z. Linux' manpages
describes it as:
z A following integer conversion corresponds to a size_t or ssize_t
argument.
Since gcc's printf
On 11.11.2013 14:12, Rohit Goyal wrote:
Hi,
Thanks for reply.
I actually want to make some changes in all operations on index like
insert, update, delete.
for example, i want store a new customized value for every key inserted in
b tree instead of storing Tuple Id as value.
That sounds pretty
On 11/10/2013 12:57 AM, Robert Haas wrote:
On Thu, Nov 7, 2013 at 10:56 AM, Antonin Houska
antonin.hou...@gmail.com wrote:
catalog/catalog.c:GetNewRelFileNode() and its calls indicate that the
following change makes sense:
diff --git a/src/include/storage/relfilenode.h
On 2013-11-11 17:33:53 +0100, Andres Freund wrote:
On 2013-11-11 11:18:22 -0500, Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
I'd like to add support for the length modifier %z. Linux' manpages
describes it as:
z A following integer conversion corresponds to a
Andres Freund and...@2ndquadrant.com writes:
On 2013-11-11 11:18:22 -0500, Tom Lane wrote:
I think you'll find that %m is a totally different animal, because it
doesn't involve consuming an argument position.
I was thinking of just replacing '%z' by '%l', '%ll' or '%' as needed
and not
Hi,
Can you pls tel me how can achieve which sound pretty exotic to you.
Can u please share some relevant documents. I havw no clue from where to
start.
Regards
Rohit
On 11.11.2013 14:12, Rohit Goyal wrote:
Hi,
Thanks for reply.
I actually want to make some changes in all operations on
On Mon, Nov 11, 2013 at 12:53 AM, Erik Rijkers e...@xs4all.nl wrote:
On Fri, November 8, 2013 21:11, Alvaro Herrera wrote:
Here's a version 7 of the patch, which fixes these bugs and adds
opclasses for a bunch more types (timestamp, timestamptz, date, time,
timetz), courtesy of Martín
Andres Freund and...@2ndquadrant.com writes:
gettext has support for it afaics, it's part of POSIX:
Really? [ pokes around at pubs.opengroup.org ] Hm, I don't see it
in Single Unix Spec v2 (1997), but it is there in POSIX issue 7 (2008).
Also, the POSIX page says it defers to the C standard,
On 2013-11-11 12:01:40 -0500, Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
I'm less than sure that every version of gcc will recognize %z, either
...
It's been in recognized in 2.95 afaics, so I think we're good.
Hm. Strange. Has to have been backpatched to the ancient
On Mon, Nov 11, 2013 at 10:50 AM, Andres Freund and...@2ndquadrant.com wrote:
Hi,
I'd like to add support for the length modifier %z. Linux' manpages
describes it as:
z A following integer conversion corresponds to a size_t or ssize_t
argument.
Since gcc's printf format checks
On 2013-11-11 12:18:46 -0500, Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
gettext has support for it afaics, it's part of POSIX:
Really? [ pokes around at pubs.opengroup.org ] Hm, I don't see it
in Single Unix Spec v2 (1997), but it is there in POSIX issue 7 (2008).
On 2013-11-11 12:31:55 -0500, Robert Haas wrote:
On Mon, Nov 11, 2013 at 10:50 AM, Andres Freund and...@2ndquadrant.com
wrote:
Hi,
I'd like to add support for the length modifier %z. Linux' manpages
describes it as:
z A following integer conversion corresponds to a size_t or
On 11/8/13 2:21 PM, Tom Lane wrote:
Jim Nasby jna...@enova.com writes:
Ahh, duh. Hrm... I ran across this because someone here got confused by this:
SELECT pg_total_relation_size( schema_name || '.' || relname ) FROM
pg_stat_all_tables
ERROR: relation moo does not exist
Personally I'd do
Hi,
Instead of de-supporting platforms that don't have CAS support or
providing parallel implementations we could relatively easily build a
spinlock based fallback using the already existing requirement for
tas().
Something like an array of 16 spinlocks, indexed by a more advanced
version of
On 2013-11-10 14:45:17 -0500, Steve Singer wrote:
On 11/10/2013 09:41 AM, Andres Freund wrote:
Still give me the following:
update disorder.do_inventory set ii_in_stock=2 where ii_id=251;
UPDATE 1
test1=# LOG: tuple in table with oid: 35122 without primary key
Hm. Could it be that you
On 11/11/13, 10:26 AM, Tom Lane wrote:
Peter Eisentraut pete...@gmx.net writes:
Fix whitespace issues found by git diff --check, add gitattributes
Set per file type attributes in .gitattributes to fine-tune whitespace
checks. With the associated cleanups, the tree is now clean for git
Hmm,
On Mon, Nov 11, 2013 at 01:42:07AM +0100, Andres Freund wrote:
Hi,
On 2013-11-10 17:40:31 -0700, Noah Yetter wrote:
Like your customer, this bug has blown up my standby servers, twice in the
last month: the first time all 4 replicas, the second time (mysteriously
but luckily) only 1 of
Hi,
Actually,
I want to test an algorithm in which I will use store tuple_id in some
other data structure and value of the key of index will contain some random
created by me. Could you please tel me which file need to be change for it.
you said something about usage of GiST opclass. Can you
On 11/11/2013 02:17 PM, Peter Eisentraut wrote:
On 11/11/13, 10:26 AM, Tom Lane wrote:
Peter Eisentraut pete...@gmx.net writes:
Fix whitespace issues found by git diff --check, add gitattributes
Set per file type attributes in .gitattributes to fine-tune whitespace
checks. With the
Jim Nasby jna...@enova.com writes:
Is anyone opposed to some kind of hint?
Would depend on the text of the hint. I'm a bit dubious that we can
come up with something that's not wildly inappropriate in other scenarios.
regards, tom lane
--
Sent via pgsql-hackers
Bruce Momjian br...@momjian.us writes:
On Mon, Nov 11, 2013 at 01:42:07AM +0100, Andres Freund wrote:
The fix is included in 9.2.5, it's just not noted in the release notes.
Yes, I missed it because I didn't understand the importance of these
commit messages:
commit
I can agree, so DROP TRIGGER doesn't need a IF EXISTS clause when it is
executed after DROP TABLE.
pg_dump -c produces:
DROP TRIGGER jjj ON public.foo;
DROP TABLE public.foo;
DROP FUNCTION public.f1();
DROP EXTENSION plpgsql;
DROP SCHEMA public;
Is there some reason why we use explicitly DROP
2013/11/11 Tom Lane t...@sss.pgh.pa.us
Andres Freund and...@2ndquadrant.com writes:
Turns out that's bogus - ALTER TABLE has two levels of NOT EXISTS.
Maybe we should just do the same for DROP TRIGGER?
DROP TRIGGER [ IF EXISTS ] name ON table_name [ IF EXISTS ] [ CASCADE |
RESTRICT ]
Andres Freund and...@2ndquadrant.com writes:
On 2013-11-11 12:31:55 -0500, Robert Haas wrote:
I seem to recall that our %m support involves rewriting the error
string twice, which I think is actually kind of expensive if, for
example, you've got a loop around a PL/pgsql EXCEPTION block.
Yes,
In playing with a sample query from another thread I found this
query is broken on the master branch:
select q1.*
from (select 'a'::text) q1(c)
where not exists
(select * from (select 'A'::text) q2(c) where q2 = q1);
I get:
ERROR: subquery q2 does not have attribute 0
I checked and
Kevin Grittner kgri...@ymail.com writes:
I get:
ERROR: subquery q2 does not have attribute 0
I checked and found it broken on 9.2 and 9.3, but working on 9.1.
git bisect, says it was broken by commit
1cb108efb0e60d87e4adec38e7636b6e8efbeb57.
My fault, eh? Will look.
On Thu, Nov 7, 2013 at 12:18 PM, Andres Freund and...@2ndquadrant.com wrote:
On 2013-11-07 10:10:34 -0500, Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
On 2013-11-07 06:49:58 -0800, Kevin Grittner wrote:
It's up to the committer whether to indent
after review and make both
On Mon, Nov 11, 2013 at 4:00 PM, Robert Haas robertmh...@gmail.com wrote:
On Thu, Nov 7, 2013 at 12:18 PM, Andres Freund and...@2ndquadrant.com wrote:
On 2013-11-07 10:10:34 -0500, Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
On 2013-11-07 06:49:58 -0800, Kevin Grittner wrote:
2013/11/11 Pavel Stehule pavel.steh...@gmail.com
2013/11/11 Tom Lane t...@sss.pgh.pa.us
Andres Freund and...@2ndquadrant.com writes:
Turns out that's bogus - ALTER TABLE has two levels of NOT EXISTS.
Maybe we should just do the same for DROP TRIGGER?
DROP TRIGGER [ IF EXISTS ] name
Robert Haas robertmh...@gmail.com schrieb:
On Mon, Nov 11, 2013 at 4:00 PM, Robert Haas robertmh...@gmail.com
wrote:
On Thu, Nov 7, 2013 at 12:18 PM, Andres Freund
and...@2ndquadrant.com wrote:
On 2013-11-07 10:10:34 -0500, Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
On
On Wed, Nov 6, 2013 at 1:38 AM, Craig Ringer cr...@2ndquadrant.com wrote:
(a) Updatable views are implemented in the rewriter, not the planner.
The rewriter is not re-run when plans are invalidated or when the
session authorization changes, etc. This means that we can't simply omit
the RLS
On Thu, Nov 7, 2013 at 9:08 PM, Craig Ringer cr...@2ndquadrant.com wrote:
On 11/07/2013 09:47 PM, Greg Stark wrote:
Incidentally I still feel this is at root the problem with updateable
views in general. I know it's a bit off to be tossing in concerns from
the peanut gallery when I'm not
On Thu, Nov 7, 2013 at 8:21 PM, Greg Stark st...@mit.edu wrote:
The most interesting thing that I could see calculating from these stats
would require also knowing how much time was spent waiting on writes and
reads on the network. With the cumulative time spent as well as the count of
[moving the discussion to pgsql-hackers]
Jeffrey Walton noloa...@gmail.com wrote:
The Analyzer is invoked with scan-build. Its used when compiling
the package because it performs static analysis.
The Santizers are invoked with the runtime flags. They are used
with the `check` program
On 11/11/2013 06:24 AM, Stephen Frost wrote:
* Rafael Martinez (r.m.guerr...@usit.uio.no) wrote:
* We need a pg_dump solution that can generate in one step all the
necessary pieces of information needed when restoring or cloning a
database. (schema, data, privileges, users and alter
On Mon, Nov 11, 2013 at 2:18 PM, Kevin Grittner kgri...@ymail.com wrote:
I'm currently capturing a text version of all the warnings from
this. Will gzip and post when it finishes. It's generating a lot
of warnings; I have no idea how many are PostgreSQL problems and
how many are false
On Mon, Nov 11, 2013 at 5:29 PM, Peter Geoghegan p...@heroku.com wrote:
On Mon, Nov 11, 2013 at 2:18 PM, Kevin Grittner kgri...@ymail.com wrote:
I'm currently capturing a text version of all the warnings from
this. Will gzip and post when it finishes. It's generating a lot
of warnings; I
Andrew Dunstan wrote
A general ability to rename things would be good. In particular,
restoring schema x into schema y or table x into table y would be very
useful, especially if you need to be able to compare old with new.
compare old and new what? I would imagine that schema comparisons
On Mon, Nov 11, 2013 at 2:45 PM, Jeffrey Walton noloa...@gmail.com wrote:
I think you are right. Coverity is a very nice tool, and Clang has
some growing to do.
To be fair to the LLVM/Clang guys, it's not as if static analysis is a
very high priority for them.
--
Peter Geoghegan
--
Sent
On Mon, Nov 11, 2013 at 5:18 PM, Kevin Grittner kgri...@ymail.com wrote:
[moving the discussion to pgsql-hackers]
Jeffrey Walton noloa...@gmail.com wrote:
...
##
# Sanitizers
make distclean
export DYLD_FALLBACK_LIBRARY_PATH=/usr/local/lib/clang/3.3/lib/darwin/
export
On Mon, Nov 11, 2013 at 5:51 PM, Peter Geoghegan p...@heroku.com wrote:
On Mon, Nov 11, 2013 at 2:45 PM, Jeffrey Walton noloa...@gmail.com wrote:
I think you are right. Coverity is a very nice tool, and Clang has
some growing to do.
To be fair to the LLVM/Clang guys, it's not as if static
Peter Geoghegan p...@heroku.com wrote:
Kevin Grittner kgri...@ymail.com wrote:
I'm currently capturing a text version of all the warnings from
this. Will gzip and post when it finishes. It's generating a lot
of warnings; I have no idea how many are PostgreSQL problems and
how many are
Josh Berkus wrote
Well, then we just need pg_restore to handle the role already exists
error message gracefully. That's all. Or a CREATE ROLE IF NOT EXISTS
statement, and use that for roles.
My only qualm here is if the exists check is based off of role name only.
If database A and database
On 11/11/2013 03:06 PM, David Johnston wrote:
Josh Berkus wrote
Well, then we just need pg_restore to handle the role already exists
error message gracefully. That's all. Or a CREATE ROLE IF NOT EXISTS
statement, and use that for roles.
My only qualm here is if the exists check is based
On Tue, Nov 5, 2013 at 9:52 AM, Leonardo Francalanci m_li...@yahoo.itwrote:
Jeff Janes wrote
Some experiments I did a few years ago showed that applying sorts to the
data to be inserted could be helpful even when the sort batch size was as
small as one tuple per 5 pages of existing index.
On Mon, Nov 11, 2013 at 6:01 PM, Kevin Grittner kgri...@ymail.com wrote:
Peter Geoghegan p...@heroku.com wrote:
Kevin Grittner kgri...@ymail.com wrote:
I'm currently capturing a text version of all the warnings from
this. Will gzip and post when it finishes. It's generating a lot
of
On Thu, Oct 31, 2013 at 12:43 AM, Leonardo Francalanci m_li...@yahoo.itwrote:
Jeff Janes wrote
True, but that is also true of indexes created in bulk. It all has to
reach disk eventually--
[...]
If the checkpoint interval is as long as the partitioning period, then
hopefully the
On 11/11/2013 05:50 PM, David Johnston wrote:
Andrew Dunstan wrote
A general ability to rename things would be good. In particular,
restoring schema x into schema y or table x into table y would be very
useful, especially if you need to be able to compare old with new.
compare old and new
Kevin Grittner kgri...@ymail.com writes:
It does seem hard to believe that clang tools would find as enough
problems that were missed by Coverity and Valgrind to account for
all the warnings that are scrolling by; but it looks like it has
pointed out at least *one* problem that's worth fixing.
On Mon, Nov 11, 2013 at 8:20 PM, Josh Berkus j...@agliodbs.com wrote:
[...]
Well, then we just need pg_restore to handle the role already exists
error message gracefully. That's all. Or a CREATE ROLE IF NOT EXISTS
statement, and use that for roles.
I'm working in a patch to add IF NOT
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 Kapila wrote:
I am not sure whether the same
On 11/11/2013 06:37 PM, Kohei KaiGai wrote:
Hi Craig,
I'd like to vote the last options. It is a separate problem (or, might
be specification), I think.
I tend to agree, but I'm nervous about entirely hand-waving around this,
as doing so would *expand* the existing problem.
Solving this
On Mon, Nov 11, 2013 at 10:17:54AM +0100, Boszormenyi Zoltan wrote:
The old contents of my GIT repository was removed so you need to
clone it fresh. https://github.com/zboszor/ecpg-readahead.git
I won't post the humongous patch again, since sending a 90KB
compressed file to everyone on the
On 11/12/2013 05:40 AM, Robert Haas wrote:
I haven't studied this issue well enough to know what's really needed
here, but Dean Rasheed's approach sounded like a promising tack to me.
I've been looking further into adding update support for security
barrier views and after reading the code for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/11/2013 09:59 PM, Rafael Martinez wrote:
* We need a pg_dump solution that can generate in one step all the
necessary pieces of information needed when restoring or cloning a
database. (schema, data, privileges, users and alter
On 11/12/2013 03:26 AM, Rohit Goyal wrote:
Hi,
Actually,
I want to test an algorithm in which I will use store tuple_id in some
other data structure and value of the key of index will contain some
random created by me. Could you please tel me which file need to be
change for it.
you
On Tue, Nov 12, 2013 at 11:53 AM, Craig Ringer cr...@2ndquadrant.com wrote:
On 11/12/2013 03:26 AM, Rohit Goyal wrote:
Hi,
Actually,
I want to test an algorithm in which I will use store tuple_id in some
other data structure and value of the key of index will contain some
random created by
Craig Ringer cr...@2ndquadrant.com writes:
On 11/12/2013 05:40 AM, Robert Haas wrote:
I haven't studied this issue well enough to know what's really needed
here, but Dean Rasheed's approach sounded like a promising tack to me.
I've been looking further into adding update support for security
On 11/12/2013 02:35 PM, Tom Lane wrote:
[ lots o details snipped ]
Totally crazy? Or workable? I'm extremely new to the planner, so I know
this might be unworkable, and would value advice.
The main omission I notice in your sketch is that the join tree that is
the source of tuples has to
I'd be much more impressed by seeing a road map for how we get to a
useful amount of added functionality --- which, to my mind, would be
the ability to support N different encodings in one database, for N2.
But even if you think N=2 is sufficient, we haven't got a road map, and
commandeering
92 matches
Mail list logo