range suggested by you;
3 - The two cheap HDs above in Raid 0.
There will be 4 GB of memory, Fedora 8 and Postgresql 8.3.
Regards,
Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 4: Have you searched our list archives?
___51212______34832
Any idea about what could be wrong or how to investigate it?
Regards, Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
2008/1/4, Tom Lane <[EMAIL PROTECTED]>:
> Clodoaldo <[EMAIL PROTECTED]> writes:
> > The same insert query takes 20 minutes in the production system and 2
> > hours in the new one.
>
> Hmph. It's the same plan, so it's not a planner mistake. Could
2008/1/5, Greg Smith <[EMAIL PROTECTED]>:
> On Fri, 4 Jan 2008, Clodoaldo wrote:
>
> > I built a new system and installed 8.3-beta4.
>
> How did you get 8.3-beta4?
I built from the source rpm, which i installed in my machine. There is
something I forgot to mention. I c
2008/1/5, Tom Lane <[EMAIL PROTECTED]>:
> Clodoaldo <[EMAIL PROTECTED]> writes:
> >> How did you get 8.3-beta4?
>
> > I built from the source rpm, which i installed in my machine. There is
> > something I forgot to mention. I created a patch to cha
ng
---+--+---
fahstats | cpn | SQL_ASCII
postgres | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(4 rows)
Regards, Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 1: if posting/read
2008/1/6, Magnus Hagander <[EMAIL PROTECTED]>:
> Clodoaldo wrote:
> > I'm the owner of a database and when i issue an analyze command on it,
> > the pg tables are skipped with the message that only the owner can
> > analyze them:
> >
> > $ psql fahst
2008/1/6, Scott Marlowe <[EMAIL PROTECTED]>:
> On Jan 6, 2008 5:06 AM, Clodoaldo <[EMAIL PROTECTED]> wrote:
> >
> > Then I rebuilt and reinstalled postgresql with the xlog_seg_size set
> > to the default 16MB and did initdb. Now the time is 7,642 sec.
&g
2008/1/7, Scott Marlowe <[EMAIL PROTECTED]>:
> On Jan 6, 2008 1:46 PM, Clodoaldo <[EMAIL PROTECTED]> wrote:
> > 2008/1/6, Scott Marlowe <[EMAIL PROTECTED]>:
> >
> > > On Jan 6, 2008 5:06 AM, Clodoaldo <[EMAIL PROTECTED]> wrote:
> > > >
2008/1/7, Greg Smith <[EMAIL PROTECTED]>:
> On Mon, 7 Jan 2008, Clodoaldo wrote:
>
> > I just did it. Built and installed 8.2.5. Copied the postgresql.conf
> > from the production. Issued an analyze and ran the insert query twice:
> > The second time it ran in 403
2008/1/8, Alvaro Herrera <[EMAIL PROTECTED]>:
> Clodoaldo escribió:
>
> 8.2:
>
> > Trigger for constraint datas: time=14231.240 calls=880691
> > Total runtime: 356862.302 ms
> > (12 rows)
> >
> > Time: 357750.531 ms
>
> 8.3:
>
>
part what make
them expensive, can spend lots of time persuading and can offer good
money to those who decide which is the "best" product. Those who
decide are not the coders or db admins and in general don't really
care much.
Regards, Clodoaldo Pinto Neto
-
2008/1/8, Clodoaldo <[EMAIL PROTECTED]>:
> 2008/1/8, Alvaro Herrera <[EMAIL PROTECTED]>:
> > Clodoaldo escribió:
> >
> > 8.2:
> >
> > > Trigger for constraint datas: time=14231.240 calls=880691
> > > Total runtime: 356862.302 ms
&g
uery is just a corner case, but I don't believe it. I posted about it
but the whole thread disappeared from the archives. It can still be
found here:
http://archives.free.net.ph/message/20080105.004509.22be255d.es.html
Could you try 8.3 and see what happens? Keep the
2008/1/10, Martijn van Oosterhout <[EMAIL PROTECTED]>:
> On Thu, Jan 10, 2008 at 01:50:42PM -0200, Clodoaldo wrote:
> > I posted about it
> > but the whole thread disappeared from the archives. It can still be
> > found here:
> >
> &
2008/1/10, Scott Marlowe <[EMAIL PROTECTED]>:
> On Jan 10, 2008 9:50 AM, Clodoaldo <[EMAIL PROTECTED]> wrote:
> > 2008/1/10, Sim Zacks <[EMAIL PROTECTED]>:
> > > I just upgraded my database server from 8.0.1 to 8.2.4
> > > Most things went very wel
2008/1/10, Scott Marlowe <[EMAIL PROTECTED]>:
> On Jan 10, 2008 9:50 AM, Clodoaldo <[EMAIL PROTECTED]> wrote:
>
> > I have seen performance degradation at every new version since 7.3.
> > But now 8.3 is a complete disaster. It could be that my most expensive
> >
QUERY PLAN
-
Function Scan on generate_series i (cost=0.00..12.50 rows=1000
width=4) (actual time=196.804..553.617 rows=80 loops=1)
Total runtime: 11202.895 ms
(2 rows)
The real table has foreign keys. Don't it make a difference?
I can reinstall 8.3 and try it. Will it be necessary or interesting?
beta4 or RC1?
Regards, Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
2008/1/10, Clodoaldo <[EMAIL PROTECTED]>:
> 2008/1/10, Tom Lane <[EMAIL PROTECTED]>:
> > It would be interesting to see the identical test on Clodaldo's
> > installations.
>
> This is 8.2.6 in the new server:
>
> cpn=> create table foo (f1 int,
2008/1/11, Clodoaldo <[EMAIL PROTECTED]>:
> 2008/1/10, Clodoaldo <[EMAIL PROTECTED]>:
> > 2008/1/10, Tom Lane <[EMAIL PROTECTED]>:
> > > It would be interesting to see the identical test on Clodaldo's
> > > installations.
> >
> > This
dsum is null then 0 else b.deliveredsum end > 0
>
> It is butt ugly, but is that the most efficient way to write it in 8.2.4?
I don't know if the plan would be the same but this is a bit clearer:
WHERE COALESCE(b.quantity, 0) > COALESCE(b.deliveredsum, 0)
Regards, Clodoaldo Pinto Neto
---
2008/1/15, Alvaro Herrera <[EMAIL PROTECTED]>:
> Clodoaldo escribió:
>
> > I guess the samples above are not very useful. If you think it would
> > help, i can upload the database dump, along with the source txt files
> > and the insert script, to some web directory,
> I'm thinking it's still not right :
I will test both 8.2 and 8.3 again in the old box which is now retired
and don't have the raid factor.
Regards, Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
t test 8.3 on the old box. Now the new box is already the
production box running 8.2.6 and I can't test on it anymore, but I can
test everything again in the old box. That would rule out the raid
factor. I will have to wait for the weekend.
Regards, Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
9) (actual
time=0.080..1158.713 rows=877935 loops=1)
Trigger for constraint datas: time=44379.117 calls=877895
Total runtime: 8865110.176 ms
(13 rows)
Time: 8865629.601 ms
Both versions where analized before running.
The old server reproduces the behavior of the new one.
Regards, Clodoaldo Pinto Neto
---
2008/1/20, Tom Lane <[EMAIL PROTECTED]>:
> Clodoaldo <[EMAIL PROTECTED]> writes:
> > 2008/1/16, Tom Lane <[EMAIL PROTECTED]>:
> >> I don't know of any reason to think that insertion is slower in 8.3
> >> than it was in 8.2, and no one else has r
he
> performance increase as a goal or it was simply a required change to support
> some other new feature of 8.3? Right now the switch from 8.2 to 8.3 doesn't
> seems a favorable step for the type of application that we have...
Vlad,
What happens if you run the 8.3 test with enab
I just ANALYZEd the database and times are back to normal. Sorry for the noise.
Regards, Clodoaldo Pinto Neto
2008/2/27, Clodoaldo <[EMAIL PROTECTED]>:
> Postgresql 8.2.6, Fedora 8, 2 GB memory.
>
> A query that used to perform in a few seconds is now taking 64 seconds
&
me=3.589..3.589 rows=1 loops=823)
-> Index Scan Backward using pk_data on datas
(cost=0.00..780.05 rows=32 width=12) (actual time=3.588..3.588 rows=1
loops=823)
Filter: (date_trunc('day'::text, data) =
date_trunc('day
some reason for the insert syntax to be the way it is in
instead of the much easier to get it right Update syntax?:
update my_table
set a = @a,
b = @b,
c = @c,
...
Regards, Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 1: if posting/reading through
2008/2/29, Martijn van Oosterhout <[EMAIL PROTECTED]>:
> On Fri, Feb 29, 2008 at 01:17:20PM -0300, Clodoaldo wrote:
> > When inserting into a table and there are many columns to be inserted
> > it is hard to synchronize columns to values:
>
>
>
>
>
>
Update syntax then please elaborate on
it.
Regards, Clodoaldo Pinto Neto
> In very rough psuedo-code, something like
>
> create my_data_structure {
>table = employees,
>first_name = sally,
>last_name = smith,
>date_of_b
15-137.fc8, the default in grub.conf and rebooted.
How do I know if the database is corrupted? Since there is no explain
for reindex or vacuum i don't know what is happening. How to debug?
Regards, Clodoaldo Pinto Neto
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
2008/3/13, Alvaro Herrera <[EMAIL PROTECTED]>:
> Clodoaldo escribió:
>
>
> > Now what is happening is that reindex does not finish even with a
> > small 6,500 rows table and after a reboot. In top there is no CPU or
> > memory usage by postmaster and vmstat
2008/3/13, Greg Smith <[EMAIL PROTECTED]>:
> On Thu, 13 Mar 2008, Clodoaldo wrote:
>
> > I recently had a crash during a bulk insert when i updated to the
> > 2.6.24.3-12.fc8 kernel. I rebooted and Postgresql did its thing to
> > recover and everything was worki
2008/3/13, Alvaro Herrera <[EMAIL PROTECTED]>:
> Clodoaldo escribió:
>
> > 2008/3/13, Alvaro Herrera <[EMAIL PROTECTED]>:
> > > Clodoaldo escribió:
> > >
> > >
> > > > Now what is happening is that reindex does not finish even wit
2008/3/14, Scott Marlowe <[EMAIL PROTECTED]>:
> On Thu, Mar 13, 2008 at 5:49 PM, Clodoaldo
> <[EMAIL PROTECTED]> wrote:
> > 2008/3/13, Alvaro Herrera <[EMAIL PROTECTED]>:
> > > Clodoaldo escribió:
> > >
> > > > 2008/3/13, Alvaro
2008/3/14, Pavan Deolasee <[EMAIL PROTECTED]>:
> On Fri, Mar 14, 2008 at 5:19 AM, Clodoaldo
>
> <[EMAIL PROTECTED]> wrote:
>
> >
>
> > > Try vacuuming pg_class, pg_index, pg_attribute manually and see if that
> > > makes the problem go away
2008/3/14, Alvaro Herrera <[EMAIL PROTECTED]>:
> Clodoaldo escribió:
>
>
> > Postgresql was restarted twice, but yes, it is as if the crash left
> > some kind of permanent lock somewhere.
>
>
> A prepared transaction perhaps? SELECT * FROM pg_prepared_xa
2008/3/14, Alvaro Herrera <[EMAIL PROTECTED]>:
> Clodoaldo escribió:
>
> > 2008/3/14, Alvaro Herrera <[EMAIL PROTECTED]>:
>
>
> > > A quick look into pg_locks should tell you if it's blocking.
> >
> > pg_prepared_xacts is empty and pg_lock
2008/3/13, Alvaro Herrera <[EMAIL PROTECTED]>:
> Clodoaldo escribió:
>
> > 2008/3/13, Alvaro Herrera <[EMAIL PROTECTED]>:
> > > Clodoaldo escribió:
> > >
> > >
> > > > Now what is happening is that reindex does not finish even wit
2008/3/26, Alvaro Herrera <[EMAIL PROTECTED]>:
> Clodoaldo escribió:
>
>
> > The database performance slowly degrades and after two weeks i issue a
> > reindex on the database and the performance gets back to normal. I
> > have been doing this for ages and
According to Slashdot IBM is investing in EnterpriseDB. What does it
mean for Postgresql?
Regards, Clodoaldo Pinto Neto
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
7-01 18:09:17.644706+00
,,\\252yS\\337\\211\\273\\034TJV9/\\303\\330[/o\\2519094t
f 0
I can't see what the error is. The source database is working
correctly and selecting the offending row raises no problem. I tried
dumping and downloading again but same error.
Regards, Clodoald
My mistake. Sorry for the noise.
Regards, Clodoaldo
2008/4/12, Clodoaldo <[EMAIL PROTECTED]>:
> I dumped the db with:
> pg_dump -C -f dbname.dump
>
> $ uname -a
> Linux myhost.mydomain.net 2.6.22.14-72.fc6 #1 SMP Wed Nov 21 14:10:25
> EST 2007 x86_64 x86_64 x86_64 G
What should be changed in the query planning configuration, if at all,
if a ultrafast solid state drive would be used to host a whole
database ? Specially if used in Raid 0 configurations.
Regards, Clodoaldo Pinto Neto
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
2008/5/30 Merlin Moncure <[EMAIL PROTECTED]>:
> On Fri, May 30, 2008 at 11:43 AM, Clodoaldo
> <[EMAIL PROTECTED]> wrote:
>> What should be changed in the query planning configuration, if at all,
>> if a ultrafast solid state drive would be used to host a whole
>
ld be very fast.
Regards, Clodoaldo Pinto Neto
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
IALIZABLE;');
rs1 = cursor.execute(query_1, (param1,))
rs2 = cursor.execute(query_2, (param2,))
cursor.execute('commit;');
cursor.close()
connection.close()
I tested it and it raises no exception. I just don't understand if a
transaction persists between execute() calls.
Reg
miliar with the python library, but that looks correct to me.
> You can always test it by adding a sleep between your two queries and
> modifying the database from a console connection during the sleep.
>
> Note that I'm assuming your 5 queries are all read-only selects.
&g
om test_table
where tname !~ E'\\[.*\\]'
) as a
group by tname
order by tname;
The result which is correct:
total | tname | value_total
---+---+-
4 | [AB] | 14
1 | [abx | 4
1 | ab]x | 5
1 | xyz | 6
1 | Xyz | 7
(5 rows
2006/12/18, Jeff Davis <[EMAIL PROTECTED]>:
On Fri, 2006-12-15 at 17:21 -0200, Clodoaldo wrote:
> -- drop table test_table;
> create table test_table (tname varchar, value integer);
> insert into test_table values ('[ab]x', 1);
> insert into test_table values
est practice in this situation? I mean not only the two
options as above but any.
Regards,
--
Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 6: explain analyze is your friend
te...
Where can I find the 8.2.1 release notes? It is not in this page:
http://www.postgresql.org/developer/testing
Regards,
--
Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
esql function/utility that will "server" the
file from the file system based on the reference/link embeded in the
database ??
I think some procedure languages can read files. In this case what
would be the gain in introducing a middle man, the db server?
Regards,
--
Clodoaldo Pi
internet
client's bandwidth limitations? Or they just assume the application
would handle the HTTP cache headers? In the applications I created for
intranet bandwidth was almost a non issue and I didn't care to make
them bandwidth efficient, but for the internet the problem
p this argument by the way.
Sorry, I understood you were talking about server side caching while
what I refer to is client side caching.
Regards,
--
Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
2007/1/6, Maurice Aubrey <[EMAIL PROTECTED]>:
Clodoaldo wrote:
> But the main factor to push me in the file system direction is the
> HTTP cache management. I want the internet web clients and proxies to
> cache the images. The Apache web server has it ready and easy. If
> t
it does not make a
difference. It is just that it is bad behavior from postgresql
community people. A shame.
Regards,
--
Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
re is someone
more senior on this board that could point the way ??
I have been a newbie for a long time. What if you wrap your commands
in a function? A function is a transaction. The function can be
written in plpython if there is the need. I think that would solve
your problem.
Regards,
--
om down here? ;-)
They are certainly blocking some networks. I have a report from a guy
in Venezuela which cannot access the site when connected via CANTV, but
can access it readily when using a different provider whose name escapes
me.
Right now I can access varlena.com
ade from iso-8859-1 to utf-8:
iconv -f ISO_8859-1 -t UTF-8 mydb.dump -o mydb_utf8.dump
Regards,
--
Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 6: explain analyze is your friend
;s easy enough to just create the table before creating
the function, I'm just curious as to why it should fail)
In instead of droping and creating the table at each function
execution you could create the table only once out of the function and
then truncate it inside the function.
Regards,
the final product not
at the language in which it was written. As an example I have
installed Mediawiki (php) in instead of Moinmoin (python) because
Mediawiki is years ahead of Moinmoin.
Regards,
--
Clodoaldo Pinto Neto
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
edora-22-x86_64/
Or as source:
https://download.postgresql.org/pub/repos/yum/srpms/9.5/fedora/fedora-22-x86_64/
Where to get the plpython3 packages for 9.5?
Regards, Clodoaldo
Trying to upgrade 9.4 and 9.5 in Fedora 22:
# dnf upgrade
...
Error: Package postgresql94-9.4.7-1PGDG.f22.x86_64.rpm is not signed
Regards, Clodoaldo
://hcnkrxukvhqiww:lryfxzcmlboytgtxpsvla8h...@ec2-107-21-93-97.compute-1.amazonaws.com:5432/dearu2qcqcmi7t
but I get the error message:
Unknown token in connection string:
Is it possible to pass a URI as parameter to pgAdmin? Fedora 21,
pgadmin3_94.x86_64 1.20.0-2.f21 from pgdg-94-fedora.repo
Regards, Clodoaldo
.26 rows=10 width=4)
Regards, Clodoaldo
Requires: python-flask-wtf >= 0.12
Available: python-flask-wtf-0.8-3.el7.noarch (epel)
python-flask-wtf = 0.8-3.el7
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
Regards, Clodoaldo
On Mon, Apr 24, 2017 at 11:15 AM, Adrian Klaver
wrote:
> On 04/24/2017 05:06 AM, Clodoaldo Neto wrote:
> Please reply to list also
> Ccing list
>
> On Sun, Apr 23, 2017 at 4:58 PM, Adrian Klaver
>> mailto:adrian.kla...@aklaver.com>> wrote:
>>
>
>
>>
.f26.x86_64
Psycopg2 for Python3 installs cleanly.
Regards, Clodoaldo Pinto Neto
It is fixed now. Thanks!
Clodoaldo
On Sun, Jul 16, 2017 at 8:39 AM, Devrim Gündüz wrote:
>
> Hi Clodoaldo,
>
> On Sat, 2017-07-15 at 08:38 -0300, Clodoaldo Neto wrote:
> > While installing Psycopg2 for Python2 in Fedora 26 having Postgresql 9.6:
> >
> > # dnf in
When upgrading from https://download.postgresql.org/pub/repos/yum/10/fedora/
# dnf upgrade
...
Error: Package postgresql10-10.1-1PGDG.f25.x86_64.rpm is not signed
Regards, Clodoaldo
Sorry if it is already known but just to be sure the 8.2.14 source
rpms are missing from the yum repository.
Regards, Clodoaldo
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2009/9/12 Devrim GÜNDÜZ :
> On Sat, 2009-09-12 at 12:22 -0300, Clodoaldo Neto wrote:
>
>> Sorry if it is already known but just to be sure the 8.2.14 source
>> rpms are missing from the yum repository.
>
> Because of bandwith issues on the master RPM build server, srpms a
st in case it matters.
Regards, Clodoaldo
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2009/9/18 Devrim GÜNDÜZ :
> Hi Clodoaldo,
>
> On Fri, 2009-09-18 at 19:42 -0300, Clodoaldo Neto wrote:
>>
>> # rpm -Uhv postgresql-8.2.14-1PGDG.f11.src.rpm
>> warning: postgresql-8.2.14-1PGDG.f11.src.rpm: Header V4 DSA signature:
>> NOKEY, key ID 442df0f8
>&
unrecognized configuration parameter
"unix_socket_directory"
stopped waiting
pg_ctl: could not start server
That parameter was replaced by unix_socket_directories (plural) in 9.3. But
the server version being started is 9.2:
$ /bin/pg_ctl --version
pg_ctl (PostgreSQL) 9.2.4
What am I missing?
Regards, Clodoaldo
RSION(cluster->major_version) < 903) ?*
*, in my case i change it to:*
*199: (GET_MAJOR_VERSION(cluster->major_version) < 900) **?*"
Clodoaldo
2013/9/18 Clodoaldo Neto
> I'm trying to upgrade Postgresql from 9.2 to 9.3 in Fedora 18 using this
> command as the
^
HINT: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
Any ideas?
Regards, Clodoaldo
2011/8/1 Clodoaldo Neto
> postgresql.x86_64 8.3.14-1PGDG.rhel5
> postgresql-server.x86_64 8.3.14-1PGDG.rhel5
>
> ERROR: operator does not exist: integer = integer
> LINE 3:inner join vendedor as v on a.ven
(
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Also I can't find dblink.sql:
# find / -name dblink.sql
What am I missing?
Regards, Clodoaldo
2012/6/11 Vibhor Kumar
>
> On Jun 11, 2012, at 11:17 AM, Clodoaldo Neto wrote:
>
> > I have postgresql91-contrib installed in Centos 6:
> >
> > # yum list installed postgresql91-contrib
> > ...
> > Installed Packages
> > postgresql91-contrib.x86_64
vacuuming I partition the table creating and
dropping tables at each bulk insert/delete would I be minimizing the SSD
wearing?
Regards, Clodoaldo
Em 26 de fevereiro de 2012 12:45, Clodoaldo Neto <
clodoaldo.pinto.n...@gmail.com> escreveu:
> When I explain a query using a partitioned table the result is the
> expected. That is, only the corrected partition is scanned. But when the
> query is inside a plpgsql function it t
o.0
Is there a clean solution to have both versions working?
Regards, Clodoaldo
/
total 12
-rw-r--r--. 1 root root 332 Feb 25 00:15 plpgsql--1.0.sql
-rw-r--r--. 1 root root 179 Feb 25 00:15 plpgsql.control
-rw-r--r--. 1 root root 381 Feb 25 00:15 plpgsql--unpackaged--1.0.sql
Regards, Clodoaldo
Em 28 de fevereiro de 2012 17:48, Devrim GÜNDÜZ escreveu:
>
> Hi,
>
> On Tue, 2012-02-28 at 17:39 -0300, Clodoaldo Neto wrote:
> > template1=# create extension plpythonu;
> > ERROR: could not open extension control file
> > "/usr/pgsql-9.1/share/extension/
Em 28 de fevereiro de 2012 17:54, Devrim GÜNDÜZ escreveu:
>
> Hi,
>
> On Tue, 2012-02-28 at 10:33 -0300, Clodoaldo Neto wrote:
>
>
>
> > Transaction Check Error:
> > file /usr/lib64/python2.6/site-packages/_pg.so from install of
> > postgresql91-python-
to the db encoding:
postgresql.conf:
#client_encoding = sql_ascii
=> show client_encoding;
client_encoding
-
SQL_ASCII
=> show server_encoding;
server_encoding
-
SQL_ASCII
What am i missing? Regards, Clodoaldo
t (c integer, foreign key (c) references tfk(c));
Regards, Clodoaldo
(1)
http://stackoverflow.com/questions/9545783/how-to-prevent-inserts-in-a-table
I had this error in the pgbouncer log file after updating to the last
version, 1.5, in Centos 6. For me the fix was to set the ownership of the
auth_file to pgbouncer. In the previous version, 1.4, it was working with
postgres as the owner of that file.
Regards, Clodoaldo
> Thanks for any tips!
> ___
> Pgbouncer-general mailing list
> pgbouncer-gene...@pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgbouncer-general
>
Em 14 de abril de 2012 09:39, raghu ram escreveu:
>
>
> On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto <
> clodoaldo.pinto.n...@gmail.com> wrote:
>
>> Em 12 de abril de 2012 14:12, Phoenix Kiula
>> escreveu:
>>
>>> I had pgbouncer working someho
2012/3/5 Clodoaldo Neto
> I have gone through the issue of making a parent table not writable. After
> discussing it (1) I adopted the trigger solution. But I think that a
> trigger is just an invisible layer over the database model and so I'm
> naively proposing a new syntax
from 2.6.9 to 2.6.10 could cause this drop in
performance?
Regards, Clodoaldo Pinto
___
Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora.
http://br.acesso.yahoo.com/ - Internet rápida e grátis
On Sun, 20 Feb 2005 12:35:02 -0300 (ART), Clodoaldo Pinto
<[EMAIL PROTECTED]> wrote:
> I made the same experience now with PG 8.01, FC3 and 512MB memory. The
> previous
> was PG 7.4.6, FC2 and 1GB.
>
> The difference in performance between kernels 2.6.9-1.724 and 2.6.10-
- table dump 3.9 MB
create_function_update_ranking_usuarios.sql - function
postgresql.conf
To test run restorecontext.sh then testit.sh
By the way, if someone knows a better way to update a ranking table,
please let me know.
Regards, Clodoaldo Pinto
l the date functions work as I need it:
order by yearweek(day, 2) desc, dayofweek(day);
Regards,
Clodoaldo Pinto
create table dates (date timestamp);
insert into dates values ('2005-08-08');
insert into dates values ('2005-08-09');
insert into dates values ('2005-08-10');
postgres and the logic of the table
at the page works for Sunday as the first day of the week. I will make
the pg query produce the same behavior as the mysql query but the pg
function behavior seems confusing.
Note how are the dates sorted at the table:
http://fahstats.com/tp.php?t=13802
Regard
2005/8/21, Stephan Szabo <[EMAIL PROTECTED]>:
> On Sat, 20 Aug 2005, Tom Lane wrote:
>
> > Clodoaldo Pinto <[EMAIL PROTECTED]> writes:
> > > I'm ordering by date just to show that sunday, the 0th day of the
> > > week, is the last day of a given
1 - 100 of 168 matches
Mail list logo
