Robert Haas wrote:
The advantage of specifying a + and a - in the type interface is that
the unit definition can then be specified as part of the type
declaration itself. So you can do:
CREATE TYPE ts_sec AS RANGE OVER timestamp (UNIT = '1s');
CREATE TYPE ts_min AS RANGE OVER timestamp (UNIT =
On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova
wrote:
> Hi,
>
> i'm startint to try Hot Standby & Streaming Replication, so i started
> a replication:
>
i think "make standbycheck" needs a little more work, why it isn't
accesible from top of source dir?
For now, to excercise it i have to do (on
2010/4/9 Greg Smith :
> The main hidden complexity in this particular project relates to handling
> view refreshes. The non-obvious problem is that when the view updates, you
> need something like a SQL MERGE to really handle that in a robust way that
> doesn't conflict with concurrent access to q
pavelbaros wrote:
I am also waiting for approval for my repository named
"materialized_view" on git.postgresql.org, so I could publish
completed parts.
Presuming that you're going to wander there and get assigned what looks
like an official repo name for this project is a bit...optimistic.
On Fri, Apr 9, 2010 at 4:08 PM, Dimitri Fontaine wrote:
> I guess a GSoC of reasonable size would be to define a spec for how to
> implement partitioning in PostgreSQL with a sound and accepted proposal
> on independent steps to contribute separately, in order to reach the
> full implementation in
On Fri, Apr 9, 2010 at 5:02 PM, Alvaro Herrera
wrote:
> Necati Batur escribió:
>
>> *Delivarables on Timeline*
...
>> *Implementation of a GUI for XQuery for the PostgreSql users (2 week)
>
> What, you will *also* implement a GUI? Gimme a break. There's no way
> you can achieve most of these in
On Fri, Apr 9, 2010 at 7:53 PM, Robert Haas wrote:
> On Fri, Apr 9, 2010 at 7:18 PM, Nathan Boley wrote:
>>> The advantage of specifying a + and a - in the type interface is that
>>> the unit definition can then be specified as part of the type
>>> declaration itself. So you can do:
>>>
>>> CREA
On Fri, Apr 9, 2010 at 7:18 PM, Nathan Boley wrote:
>> The advantage of specifying a + and a - in the type interface is that
>> the unit definition can then be specified as part of the type
>> declaration itself. So you can do:
>>
>> CREATE TYPE ts_sec AS RANGE OVER timestamp (UNIT = '1s');
>> CR
Using 9.0devel cvs HEAD, 2010.04.08.
I am trying to understand the performance difference
between primary and standby under a standard pgbench
read-only test.
server has 32 GB, 2 quadcores.
primary:
tps = 34606.747930 (including connections establishing)
tps = 34527.078068 (including connect
> The advantage of specifying a + and a - in the type interface is that
> the unit definition can then be specified as part of the type
> declaration itself. So you can do:
>
> CREATE TYPE ts_sec AS RANGE OVER timestamp (UNIT = '1s');
> CREATE TYPE ts_min AS RANGE OVER timestamp (UNIT = '1m');
>
>
2010/4/9 pavelbaros :
> Implementation: could be divided to few steps:
>
> 1) create materialized view
> - modify grammar (parser): CREATE MATERIALIZED VIEW mv_name AS SELECT ...
> - change executor, so that it will create physical table defined by select
> statement
This basically needs to work
On Fri, Apr 9, 2010 at 5:49 PM, Jeff Davis wrote:
>> It may or may not be worth building the concept of a unit
>> increment into the type interface machinery, though: one could imagine
>> two different range types built over the same base type with different
>> unit increments - e.g. one timestamp
On Thu, 2010-04-08 at 22:29 -0400, Robert Haas wrote:
> 1. knngist wants to use index scans to speed up queries of the form
> SELECT ... ORDER BY(as opposed to the
> existing machinery which only knows how to use an index for SELECT ...
> ORDER BY ).
> 2. Window functions want to define windows
On Fri, 2010-04-09 at 11:14 -0400, Robert Haas wrote:
> > range of integers with increment y, if x<>y? Maybe the increment step and
> > continuous/discrete could be typmods.
>
> Nope, not enough bits available there.
I think the problem is deeper than that. Typmods aren't carried along as
part o
On Fri, Apr 9, 2010 at 5:02 PM, Alvaro Herrera
wrote:
> Necati Batur escribió:
>
>> *Delivarables on Timeline*
>>
>> The implementation of XQuery support can ce achieved by;
>>
>> *Understanding the basics of the SQL/XML (1 week)
>>
>> *A research of on other kinds of XQuery supported DBMSs scuh a
On Fri, 2010-04-09 at 12:50 -0500, Kevin Grittner wrote:
> I just thought that if you were adding more type information,
> oriented aournd the types themselves rather than index AMs, some form
> of inheritence might fit in gracefully.
There are already some specific proposals for inheritance in da
2010/4/9 chaoyong wang :
> Hi,
> I'm using VC2005 to create PG C-language Fun in my contrib xml_index,
> which import other library, and I have add the include and lib directory by
> changing Mkvcbuild.pm and config.pl.
> But after I executed the following commands:
> build DEBUG
>
Well, If the project criterias and other neccessary information were
collected under a single link that would be great for not only gsoc students
but also for other enthusiastic students :).By provided info we would spend
less time to understand the project phases and requirements and more time on
Necati Batur escribió:
> *Delivarables on Timeline*
>
> The implementation of XQuery support can ce achieved by;
>
> *Understanding the basics of the SQL/XML (1 week)
>
> *A research of on other kinds of XQuery supported DBMSs scuh as; Oracle and
> SQLServer(1-2 week)
>
> *The design for the c
On Fri, Apr 9, 2010 at 4:37 PM, Andrew Dunstan wrote:
> (Personally I wish some SOC student would do LATERAL. It would be useful and
> is a feature of about the right size, I think).
Actually, I think that requires two rounds of significant executor
refactoring. This is round two:
http://archiv
pavelbaros wrote:
> I am also waiting for approval for my repository named
> "materialized_view" on git.postgresql.org
They seem to prefer that you get a repository under your name and
use materialized_view as a branch name. See my account on
git.postgresql.org and its serializable branch for
Hi,
i'm startint to try Hot Standby & Streaming Replication, so i started
a replication:
1) Install master server with regression database
2) Start WAL archive (archive_mode=on, archive_command='cp %p
/usr/local/pgsql/wal_archive/%f')
3) select pg_start_backup('standby test');
4) cp -R /usr/local
Hello,
I am sending my proposal on GSoC. Details are listed below. Please, if
you have ideas, tips, or if you only want to say you opinion about my
project, go ahead.
thanks,
Pavel Baros
Abstract:
It is effort to implement snapshot materialized view (are only updated
when refreshed) in Pos
Necati Batur wrote:
*IDEA:XMLQuery*
* *
*Abstract*
SQL/XML makes it possible to store your XML documents in your SQL
database, to query those documents using XPath and XQuery, and to
"publish" your existing SQL data in the form of XML documents.
*Benefits of Project*
SQL/XML is an ANSI
On Fri, Apr 9, 2010 at 4:01 PM, Yeb Havinga wrote:
> Robert Haas wrote:
>>
>> On Fri, Apr 9, 2010 at 11:07 AM, Yeb Havinga wrote:
>>
>>>
>>> .. I now see the example of different ranges in your original mail with
>>> different unit increments. Making that more general so there could be
>>> contin
Alvaro Herrera writes:
> Necati Batur escribió:
>> Hi,
>> All I want to contribute to the project a liitle. I do not claim that I can
>> actually solve all the issues about partitioning.
>> Of course there are lots of ideas ,some looks pretty easy however, the
>> distribution issue seems too attra
Robert Haas wrote:
On Fri, Apr 9, 2010 at 11:07 AM, Yeb Havinga wrote:
.. I now see the example of different ranges in your original mail with
different unit increments. Making that more general so there could be
continuous and discrete ranges and for the latter, what would the increment
be.
Robert Haas wrote:
> I dowanna rework the type system. I'm not even 100% sure I want
> to implement what I actually proposed. I do want to find out if
> people think the framework makes sense and whether it's the right
> way forward for those projects that need these features.
What you propo
Oleg Bartunov suggested that I should explicitly use
set search_path=public,pg_catalog;
That's a good tip, as I missed the info in the manual, but it solved
only one instance of my problem, namely
SELECT to_tsquery('cat & dog & mouse'); --this now works as it should
But the other instances stil
Magnus Hagander wrote:
> On Fri, Apr 9, 2010 at 16:02, Kevin Grittner
>> I assume we reject anything where what precedes the colon doesn't
>> match the current drive's designation?
>
> Define reject?
I guess I made that comment thinking about the example of usage
farther down.
> We're just
On Fri, Apr 9, 2010 at 1:13 PM, Kevin Grittner
wrote:
> As it is de rigueur for someone to escalate the proposed complexity
> of an idea by at least one order of magnitude, and everyone else has
> fallen down on this one: ;-)
Gee, thanks for filling in?
> I've often thought that if we rework th
Robert Haas wrote:
> Given a type T, I think we'd like to be able to define a type U as
> "the natural type to be added to or subtracted from T". As Jeff
> pointed out to me, this is not necessarily the same as the
> underlying type. For example, if T is a timestamp, U is an
> interval; if T i
On 04/09/2010 07:33 AM, Robert Haas wrote:
> On Fri, Apr 9, 2010 at 7:55 AM, Yeb Havinga wrote:
>> 'tagging' a datatype as a lineair order, it could automatically have a range
>> type defined on it, like done for the array types currently.
>
> The way we've handled array types is, quite frankly,
*IDEA:XMLQuery*
* *
*Abstract*
SQL/XML makes it possible to store your XML documents in your SQL database,
to query those documents using XPath and XQuery, and to "publish" your
existing SQL data in the form of XML documents.
*Benefits of Project*
SQL/XML is an ANSI and ISO standard that provi
On Fri, Apr 9, 2010 at 11:07 AM, Yeb Havinga wrote:
>
>> From the implementers perspective, IMHO an extra catalog entry in pg_type
>> is not bad on its own, you would have one anyway if the range type was
>> explicitly programmed. About different kinds of range types - I would not
>> know how to '
Necati Batur escribió:
> Hi,
> All I want to contribute to the project a liitle. I do not claim that I can
> actually solve all the issues about partitioning.
> Of course there are lots of ideas ,some looks pretty easy however, the
> distribution issue seems too attractive to me that I am dying to
From the implementers perspective, IMHO an extra catalog entry in
pg_type is not bad on its own, you would have one anyway if the range
type was explicitly programmed. About different kinds of range types -
I would not know how to 'promote' integer into anything else but just
one kind of 'ran
Robert Haas wrote:
On Fri, Apr 9, 2010 at 10:33 AM, Robert Haas wrote:
On Fri, Apr 9, 2010 at 7:55 AM, Yeb Havinga wrote:
Robert Haas wrote:
Under the first type [4pm,5pm) =
[4pm,4:59:59pm], while under the second [4pm,5pm) = [4pm,4:59pm].
Thoughts?
The examples wi
Hi,
All I want to contribute to the project a liitle. I do not claim that I can
actually solve all the issues about partitioning.
Of course there are lots of ideas ,some looks pretty easy however, the
distribution issue seems too attractive to me that I am dying to work on.
I have checked the devel
On Fri, Apr 9, 2010 at 4:10 AM, Dimitri Fontaine wrote:
> Do we want to enable support for string based ranges, as in the
> contributed prefix_range type?
Yes, probably, but that doesn't require as much knowledge of the
underlying data type, so I didn't feel it needed to be brought up in
this con
On Fri, Apr 9, 2010 at 16:02, Kevin Grittner
wrote:
> Magnus Hagander wrote:
>
>> it considers the following to be an absolute path:
>> * Anything that starts with /
>> * Anything that starst with \
>
> These aren't truly absolute, because the directory you find will be
> based on your current wo
On Fri, Apr 9, 2010 at 10:33 AM, Robert Haas wrote:
> On Fri, Apr 9, 2010 at 7:55 AM, Yeb Havinga wrote:
>> Robert Haas wrote:
>>>
>>> Under the first type [4pm,5pm) =
>>> [4pm,4:59:59pm], while under the second [4pm,5pm) = [4pm,4:59pm].
>>>
>>> Thoughts?
>>>
>>
>> The examples with units look a
On Fri, Apr 9, 2010 at 7:55 AM, Yeb Havinga wrote:
> Robert Haas wrote:
>>
>> Under the first type [4pm,5pm) =
>> [4pm,4:59:59pm], while under the second [4pm,5pm) = [4pm,4:59pm].
>>
>> Thoughts?
>>
>
> The examples with units look a lot like the IVL datatype from HL7, see
> http://www.hl7.org/v3b
On Fri, Apr 9, 2010 at 9:10 AM, Necati Batur wrote:
> I am new at open source project however in a user point of view I must
> confess that usability is a really though issue ,even if the performance of
> a database is crucial.
Sure. Nobody is saying otherwise.
> As to my idea for improve postg
Magnus Hagander wrote:
> it considers the following to be an absolute path:
> * Anything that starts with /
> * Anything that starst with \
These aren't truly absolute, because the directory you find will be
based on your current work directory's drive letter; however, if the
point is to then
Here's a thread that incorrectly started on the security list, but really is
more about functionality. Looking for comments:
The function is_absolute_path() is incorrect on Windows. As it's implemented,
it considers the following to be an absolute path:
* Anything that starts with /
* Anything tha
Hi all,
I am new at open source project however in a user point of view I must
confess that usability is a really though issue ,even if the performance of
a database is crucial.
As to my idea for improve postgresql is ;
http://www.postgresql.org/docs/current/interactive/ddl-partitioning.html in
c
On Wed, Apr 7, 2010 at 21:01, Tom Lane wrote:
> Stefan Kaltenbrunner writes:
>> Even if if keep the current fallback behaviour we should at least fix
>> the windows codepath to do the same as the unix codepath does - as in
>> actually logging that the fallback to GMT happened...
>
> +1 for that a
On Wed, Apr 7, 2010 at 21:06, Tom Lane wrote:
> I wrote:
>> ereport(LOG,
>> (errmsg("could not determine system time zone, defaulting to
>> \"%s\"", "GMT"),
>
> BTW, does anyone remember the reason for making "GMT" nonlocalizable
> in these messages? It seems more straigh
Robert Haas wrote:
Under the first type [4pm,5pm) =
[4pm,4:59:59pm], while under the second [4pm,5pm) = [4pm,4:59pm].
Thoughts?
The examples with units look a lot like the IVL datatype from HL7,
see
http://www.hl7.org/v3ballot/html/infrastructure/datatypes_r2/datatypes_r2.htm
About a type
On Wed, Apr 7, 2010 at 00:48, Tom Lane wrote:
> Magnus Hagander writes:
>> On Wed, Apr 7, 2010 at 00:02, Tom Lane wrote:
>>> Oh, another thought here: what is the effect of the combination of this
>>> with your other proposal to add more timezones to the list?
>
I've applied the patch to add th
Hello
Please find my project proposal at the following link:
https://docs.google.com/fileview?id=0B4sVSOdX9RZKNjI1MDZlNDgtZGU0MS00NDE4LThiZDItMjZhMGZkYjUzMWEx&hl=en
I would be glad to have your review/feedback on the same.
--
Regards
Dhiraj Lohiya
Hi all
I've asked related question on General list, but got no answer,
although I have been able to work around that issue a little bit.
There is one snag I encountered and I have no idea on how to work it
out.
I need to modify TSQuery object (add another operator and do some
stuff with it) - thi
On Thu, Apr 8, 2010 at 11:00 PM, Robert Haas wrote:
> I think you could shut it down at the first point at which it is
> holding no locks, rather than letting it continue recovering and
> potentially retake some new locks. That would be more consistent with
> the general idea of what a smart shut
Hi,
First, I like the way you got back to the needs before trying to
organize an approach to find a solution. Having said it allows me to cut
a lot of your text, it's the one I agree with :)
Robert Haas writes:
> Given a type T, I think we'd like to be able to define a type U as
> "the natural t
55 matches
Mail list logo