pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedCan you please suggest me some links where I can learn:
5+ messages / 4 participants
[nested] [flat]
* Can you please suggest me some links where I can learn:
@ 2013-09-05 05:13 M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
0 siblings, 2 replies; 5+ messages in thread
From: M Tarkeshwar Rao @ 2013-09-05 05:13 UTC (permalink / raw)
To: pgsql-general <pgsql-general@postgresql.org>; pgsql-performance
Hello Friends,
I want start contributing in Postgres in code level. I read some ppts and some tutorials in postgres manual.
Can you please suggest me some links where I can learn:
1. Transaction Isolation in Database
2. Query procession and possible optimizations.
3. How to improve query and its performance.
4. MVCC in detail.
Regards
Tarkeshwar
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Can you please suggest me some links where I can learn:
@ 2013-09-05 05:25 John R Pierce <pierce@hogranch.com>
parent: M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
1 sibling, 0 replies; 5+ messages in thread
From: John R Pierce @ 2013-09-05 05:25 UTC (permalink / raw)
To: pgsql-general@postgresql.org
On 9/4/2013 10:13 PM, M Tarkeshwar Rao wrote:
>
> Can you please suggest me some links where I can learn:
>
> 1.Transaction Isolation in Database
>
the documentation
> 2.Query procession and possible optimizations.
>
the source code. if there were any easy optimizations, I'm sure
they've already been taken.
> 3.How to improve query and its performance.
>
see #2 above.
> 4.MVCC in detail.
>
see answer to #1, and the source code if you want more detail.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [PERFORM] Can you please suggest me some links where I can learn:
@ 2013-09-05 15:39 Kevin Grittner <kgrittn@ymail.com>
parent: M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
1 sibling, 1 reply; 5+ messages in thread
From: Kevin Grittner @ 2013-09-05 15:39 UTC (permalink / raw)
To: M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>; pgsql-general <pgsql-general@postgresql.org>; pgsql-performance
M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com> wrote:
> I want start contributing in Postgres in code level.
Welcome! You should probably start with this page and its links:
http://wiki.postgresql.org/wiki/Developer_FAQ
> Can you please suggest me some links where I can learn:
> 1. Transaction Isolation in Database
http://www.postgresql.org/docs/current/interactive/transaction-iso.html
> 2. Query procession and possible optimizations.
http://www.postgresql.org/docs/current/interactive/overview.html
http://www.pgcon.org/2011/schedule/attachments/188_Planner%20talk.pdf
http://www.justin.tv/sfpug/b/419326732
> 3. How to improve query and its performance.
http://wiki.postgresql.org/wiki/Performance_Optimization
> 4. MVCC in detail.
http://www.slideshare.net/profyclub_ru/mvcc-unmaskedbruce-momjian
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [PERFORM] Can you please suggest me some links where I can learn:
@ 2013-09-05 22:42 Merlin Moncure <mmoncure@gmail.com>
parent: Kevin Grittner <kgrittn@ymail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Merlin Moncure @ 2013-09-05 22:42 UTC (permalink / raw)
To: Kevin Grittner <kgrittn@ymail.com>; +Cc: M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>; pgsql-general <pgsql-general@postgresql.org>; pgsql-performance
On Thu, Sep 5, 2013 at 10:39 AM, Kevin Grittner <kgrittn@ymail.com> wrote:
> M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com> wrote:
>
>> I want start contributing in Postgres in code level.
>
> Welcome! You should probably start with this page and its links:
>
> http://wiki.postgresql.org/wiki/Developer_FAQ
>
>> Can you please suggest me some links where I can learn:
>> 1. Transaction Isolation in Database
>
> http://www.postgresql.org/docs/current/interactive/transaction-iso.html
>
>> 2. Query procession and possible optimizations.
>
> http://www.postgresql.org/docs/current/interactive/overview.html
>
> http://www.pgcon.org/2011/schedule/attachments/188_Planner%20talk.pdf
>
> http://www.justin.tv/sfpug/b/419326732
>
>> 3. How to improve query and its performance.
>
> http://wiki.postgresql.org/wiki/Performance_Optimization
>
>> 4. MVCC in detail.
>
> http://www.slideshare.net/profyclub_ru/mvcc-unmaskedbruce-momjian
Another high priority thing to check out is the README files in the
code (this is mentioned tangentially in the developer FAQ).
Personally (and I'm no expert) I find some parts of the code much
easier to dive into without a lot of surrounding context than others
-- it could take a lifetime to learn it all. My advise is to start
small and pick a very specific topic and focus on that.
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [PERFORM] Can you please suggest me some links where I can learn:
@ 2013-09-05 22:53 John R Pierce <pierce@hogranch.com>
parent: Merlin Moncure <mmoncure@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: John R Pierce @ 2013-09-05 22:53 UTC (permalink / raw)
To: pgsql-general@postgresql.org
On 9/5/2013 3:42 PM, Merlin Moncure wrote:
> My advise is to start
> small and pick a very specific topic and focus on that.
my advise is to first familiarize yourself with the package from the
user perspective before even thinking of diving in and making any
changes. I say this, because the OP's questions seemed to suggest
they knew very little about PostgreSQL.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2013-09-05 22:53 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-09-05 05:13 Can you please suggest me some links where I can learn: M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
2013-09-05 05:25 ` John R Pierce <pierce@hogranch.com>
2013-09-05 15:39 ` Kevin Grittner <kgrittn@ymail.com>
2013-09-05 22:42 ` Merlin Moncure <mmoncure@gmail.com>
2013-09-05 22:53 ` John R Pierce <pierce@hogranch.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox